LiveCode Forums

Its me again. I did some experimentation to see how much difference the transaction style vs the line by line inserts makes, and there is no comparison. I can shove 60k records into a table in around 3 seconds using the begin/commit method. This is despite my crappy inefficient programming too. To g...

Found this stuff in the current sqlite docs at http://www.sqlite.org/faq.html#q19. Don't know if its possible with the embedded sqlite in rev tho, wouldn't know where to begin to try it. (19) INSERT is really slow - I can only do few dozen INSERTs per second Actually, SQLite will easily do 50,000 or...

I have another suggestion if it does turn out that the sqlite insertion portion is part of the bottleneck. (I'm guessing it is) You might try building up one large transaction (or break it into chunks) and do the insert that way. If I recall what I read correctly, each individual transaction require...

I'm kinda a recluse through lack of choice, and also through active choice. So no need to add me to the list, just glad to help. This forum here is about the most interaction I have with.. well. anyone. Not many forums where I feel comfortable enough to actually type things in, so this community mus...

I have this script for the external scrollbar Code: on scrollbarDrag newPosition set the vscroll of field "first" to newPosition set the vscroll of field "second" to newPosition end scrollbarDrag Hey sturgis, that's real neat, thank you! Sorry to be slow here but where do you put the other bit of c...

How bout something like this? edit: Don't know if you can do the same thing as this with the group scrollbar, but you can turn it off and add a seperate one and do as below. Might be able to just turn on the scrollbar on one of the fields, not any others you want to layer and use this same code, but...

I believe you can insert a standalone scrollbar and make it do what you want. check out scrollbarbeginning, scrollbarend, scrollbardrag, scrollbarlinedec, scrollbarlineinc, and all the other scrollbar* stuffs in the dictionary. Lots of interesting stuff in there i'm still trying to get a handle on. ...

Check the dictionary for tabStops, should do what you want. At least thats whats available in 3.0, don't have 2.9, but its probably there too. edit: probably need to look at formattedWidth also. I think the reason its hard to find information in the dictionary specifically pertaining to the table fi...

Thats cool too. Actually think I have a clue how it does it too, which is a miracle. :D I have been learning so much here on the forums, thx much all. Could also do this as below, but no real improvement. function datesuffix n put "th" into mysuffix if n is among "1,2,3,21,22,23" then put item n mod...

Ok, thats just cool.

Mark Smith wrote:I came up with this:

Code: Select all

function ordinate pNum
   if (char -1 of pNum is in "0456789") or (char -2 of pNum is "1") then
      put "th" into tSuffix
   else
      put item (char -1 of pNum) of "st,nd,rd" into tSuffix
   end if
   return pNum & tSuffix
end ordinate

Best,

Mark

Don't suppose VFP is tossing out any logged errors that you can look at?

Any chance it could be related to the vfp (ver 8 and 9) memo tip problem? If so, can get around it by turning off memo tips.

Kinda doubt thats it tho.

This is just plain strange, and I'm way out of my league so /shrug Haven't a clue. Its just freaky that its a single record. No clue where to start diagnosing this one.

In a development environment http://support.microsoft.com/kb/37507 indicates that you need to ensure that floating point libraries are initiated before making a call. Have you actually tried wrapping external dlls in Visual C++ Studio or something? Another answer is that it seems to be an issue lar...

Did some reasearch on this and found: * The program was compiled or linked with an option, such as /FPi87, that requires a coprocessor, but the program was run on a machine that did not have a coprocessor installed. * A format string for a printf or scanf function contained a floating-point format s...

I have something you might try just for curiosity sake. Have you tried leaving the memo alone and changing each part of the rest of the record individually to something else? I ask this because you've changed the memo field to single letters, all kinds of permutations, and only having no memo allows...