Restored from previous forum. Originally posted by Fangbeast.
Is there anyone who uses Purebasic to write to access databases regularly who could give me some examples of the RIGHT way to set it up and the limits and syntax?
I wrote a small Application called DeBased which does this (On Paul's site) but I am coming up against limitations and other problems which are certainly not covered in the SQL tutorials that I went into.
A frustrated fang.
Fangles woz ear orright den?
Using PB and SQL to write to Access
-
BackupUser
- PureBasic Guru
- Posts: 16777133
- Joined: Tue Apr 22, 2003 7:42 pm
Restored from previous forum. Originally posted by Manolo.
Hi Fang,
I recomended you the next book: Teach Yourself MySQL in 21 Days, from Mark Maslakopwski.
ISBN: 0-672-31914-4
This book have examples in the book and CD for read in Access and Write in MySQL via ODBC and another databases (All time via ODBC).
Is very best that others SQL tutorials.
Regards,
Manolo
Hi Fang,
I recomended you the next book: Teach Yourself MySQL in 21 Days, from Mark Maslakopwski.
ISBN: 0-672-31914-4
This book have examples in the book and CD for read in Access and Write in MySQL via ODBC and another databases (All time via ODBC).
Is very best that others SQL tutorials.
Regards,
Manolo
-
BackupUser
- PureBasic Guru
- Posts: 16777133
- Joined: Tue Apr 22, 2003 7:42 pm
Restored from previous forum. Originally posted by Fangbeast.
I.e using field text(20) in sql (in purebasic) is translated to char(20) for Access, varchar(20) for foxpro and ntext(20) for jet.
I am not even sure of that!!!
Regards
Fangles woz ear orright den?
Thanks manolo, if I can scrape some dollars together, I will do that. Been hurting my eyes going through translation tables on MSDN because what you type in SQL is not what ACCESS sees.Originally posted by Manolo
Hi Fang,
I recomended you the next book: Teach Yourself MySQL in 21 Days, from Mark Maslakopwski.
ISBN: 0-672-31914-4
This book have examples in the book and CD for read in Access and Write in MySQL via ODBC and another databases (All time via ODBC).
Is very best that others SQL tutorials.
Regards,
Manolo
I.e using field text(20) in sql (in purebasic) is translated to char(20) for Access, varchar(20) for foxpro and ntext(20) for jet.
I am not even sure of that!!!
Regards
Fangles woz ear orright den?
-
BackupUser
- PureBasic Guru
- Posts: 16777133
- Joined: Tue Apr 22, 2003 7:42 pm
Restored from previous forum. Originally posted by Manolo.
Yes Fang, but the problem is in ODBC drivers, not in PB commands (I think).
If you want more of MySQL and PB commands, please, see Feature Requests and Wishlists from my and Num3 (Is one request for Fred). Num3 and I, will see the maner of make and built one system for direct acces to MySQL without ODBC. Need help of experts in databases.
Regards.
Manolo (Sorry for bad english)
Yes Fang, but the problem is in ODBC drivers, not in PB commands (I think).
If you want more of MySQL and PB commands, please, see Feature Requests and Wishlists from my and Num3 (Is one request for Fred). Num3 and I, will see the maner of make and built one system for direct acces to MySQL without ODBC. Need help of experts in databases.
Regards.
Manolo (Sorry for bad english)
-
BackupUser
- PureBasic Guru
- Posts: 16777133
- Joined: Tue Apr 22, 2003 7:42 pm
Restored from previous forum. Originally posted by Fangbeast.
Fangles woz ear orright den?
That's right, I found that out after many hours of searching MSDN for ODBC translation and must have tried every translation I could think of. Next trick is to find a driver and take it apart to see what it has stored in the way of keywordsOriginally posted by Manolo
Yes Fang, but the problem is in ODBC drivers, not in PB commands (I think).
If you want more of MySQL and PB commands, please, see Feature Requests and Wishlists from my and Num3 (Is one request for Fred). Num3 and I, will see the maner of make and built one system for direct acces to MySQL without ODBC. Need help of experts in databases.
Regards.
Manolo (Sorry for bad english)
Fangles woz ear orright den?