PDA

View Full Version : found a link while searching about obdc and sql



kryton9
23-03-2007, 06:53
Eros I came across this tonight and was wondering what it is about?
http://www.koders.com/php/fid09BDD74ED1DE186FA4EBCA800ABDE966C7F21132.aspx?s=smtp%2Bserver

I am going to see if I can write something in thinBasic to help my "older brother" with SQL on paradox datafiles.
We can't get paradox to go above 130 megs, I read on the internet that it has something to with Block Sizes in paradox.
I did set the block size to the highest, but I was still getting the error.

So I will see if I can do the work in thinBasic using the ODBC module. I already am able to open the database.
In the end it will be a little over 800,000 records, so it will be interesting to work with. I never worked with that much Data!!

I can't share the data as it is for his business, but once and if I can get useful code I will share the code.

kryton9
23-03-2007, 07:23
Found this very useful site about ODBC and the commands!!

http://www.calerga.com/doc/LME_X_od.htm#odbcexecdirect

Here is the main site, I just found on MSDN. Basically it looks like we just substitute OBDC for SQL in the functions:
http://msdn2.microsoft.com/en-us/library/ms714562.aspx

ErosOlmi
23-03-2007, 08:43
Ken,

http://www.koders.com/php/fid09BDD74ED1DE186FA4EBCA800ABDE966C7F21132.aspx?s=smtp%2Bserver
is one of the many GeSHi syntax highlight keywords language files. It is produced by the attached script.
Every time I add new keywords I produce that file and upload to thinBasic server. This will let us have colored sytax scripts here in forum.
Once in a while I also send it to GeSHi project leader at http://geshi.org/

Ciao
Eros

kryton9
23-03-2007, 10:09
Oh I see, Eros, thanks was wondering what it was doing :)