Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.
ColinRule
About
- Username
- ColinRule
- Joined
- Visits
- 201
- Last Active
- Roles
- Member
Comments
-
Ran my export last night, got 50% through before I cancelled it in the morning. It ran 890,000 calls to SRP_COM passing a SQL insert, and all fine, no crashing/memory leaks. Thanks guys for a great tool. Colin
-
Thanks Don/Kevin I did not realise I also had to release objRecordSet, I was only releasing the connection object. It now goes a lot further, I presume it will run to the end, but I have such a lot of data I have not let it complete yet... 50gb in O…
-
Don, Yes, I thought a memory leak as well. Using ADO via: ConnectionString=Get_Property(@WINDOW:".CONNECTION_STRING","TEXT") Result=SRP_Com(objConnection, 'CREATE','ADODB.Connection') The connection string is Provider=SQLOLEDB.1;Server=(local)\…
-
Sorry, should have said, this is in a loop. Ie currently, CREATE, EXPORT... LOOP, RELEASE. Tried in a loop, CREATE, EXPORT, RELEASE. Both ways give out of memory and OI crash.
-
Yep, all looks good. The only other comment I would add is that the "true" is lower case, and other references to this is "True" ... and "false".
-
Thanks everyone for the fantastic turnaround. Some interesting results here. I used the OLE.AutoPopulate and it did not make much difference, but with the OI REDRAW disabled I can see the columns changing, and slowly. I then included both the REDRA…
-
Don, fair call. I will try setting the Column List property and advise. I am assuming the data remains in tact and associated with the revised ColumnList property.
-
Thanks Don. What bemuses me though is that I think this is recent. I would have noticed this on the earlier versions, ie when I wrote this code in the first place.
-
ooh, so you can, now posted as exact. I did not know how to do that. CALL SRP_Stopwatch("Reset") CALL Set_Property(TableControl,"REDRAW",0) ColumnList=Get_Property(TableControl,"OLE.ColumnList") ColCount=DCOUNT(ColumnList,@FM) For Colu…
-
Don, see post from Barry and my response. Seems the posting is not exact for the code pasted.
-
Barry The code is OK, but the paste into the formum seemed to have changed ColName = ColumnList < Column , 1 > It is as above, I added spaces all over the place in this post so that the forum shows.
-
Results with the timer around the property settings. I was wrong, there are actually 56 columns. I also commented out the setting of the Width, and it seems like the Visible property is the one causing most of the degrade. The data has to be the…
-
1. Yes the data is already loaded. The code is adjusting the info on the screen based on view settings. 2. I just ran a benchmark test CALL SRP_Stopwatch("Reset") CALL SRP_Stopwatch("Start", "SRP") CALL Set_Property(TableControl,"REDRAW",0)…
-
OK thanks. I tried this, but I must have done something wrong. I will have another go.
-
I tried that but it did not work... but then it could have been me being silly. Hiding the row indicators and adding my own is a good solution. I will look into that if no other options arise.
-
Only one read, albeit a large one. Then it does a bunch of fast SRP array functions before populating. So, not 200k reads. But having said that 4m OI reads to build the structure works at about 20k per second. Well hashed record keys and small item…
-
Thanks Kevin, generally I would do as your suggestion, and have in some other screens. This one however does not fit with that model. See example screen below. Filters in the dropdowns at the top. In this case 220,000 rows. Reads the record and popu…
-
Oh, and another question. Suppose I want to create the filtered list, any suggestions as to the best way? The SRP_Array with JOIN is useful, but when there are multi-valued columns, it is not suitable. I am thinking I just find each row, match, if …
-
Thanks, I was thinking along the same lines. My issue is that the user can update the table, and if they then apply a filter the updates wont be there. I will need to have a think if this is really an issue or not, maybe the user has to save before …
-
Sorry, I should have included more code. All rows are set visible, and redraw is set to zero at the start. CALL Set_Property(FactorTable,"OLE.Redraw",0) CALL Set_Property(FactorTable,"OLE.DataRow[All]",@FM:1)
-
Thanks "AN" works fine. This is a failure by me to read the online help :(
-
My bad, forgot to register the control. Works perfectly.
-
I have loaded and not seeing any change. Is there new format definition needed?
-
OK, no problem.
-
Wishing I hadn't asked now. :)
-
All good now, thanks Kevin. What was the cause?
-
Thanks, good luck.
-
Good question. I just tried this, doing a refresh, which redisplays, and repeating over and over. The same thing happens. As such it seems its nothing to do with the scrolling. Sorry for the confusion. I will Email a video.
-
It is all just code within the Omnievent on the form. In case its relevant the entire code is attached. My gut feeling is that it is related to the dec places and pattern, could be wrong, that is just my guess. Could be worth trying some small value…
-
Hi Relevant code below. ColumnList="" ColumnList<-1>="Id" :@VM:"Number" :@VM:"50" :@VM:0:@VM:1:@VM:0:@VM:1:@VM:0:@VM:@VM:"Left":@VM:@VM:"#" ColumnList<-1>="Group" :@VM:"Text" :@VM:"100":@VM:0:@VM:1:@VM:0:@VM:1:@VM:0:@VM:@…