Restored from previous forum. Originally posted by Manolo.
Hi Fred,
Is possible built two news commands for Database???
LastDatabaseRow --> acces to last register in one table.
SeekDatabaseRow --> acces to one especific register in one table.
Manolo
2 news commands for DataBase
-
BackupUser
- PureBasic Guru
- Posts: 16777133
- Joined: Tue Apr 22, 2003 7:42 pm
Restored from previous forum. Originally posted by Num3.
Hi Manolo,
These two commands would be usefull!
And also:
DatabaseSeek(#database,#Table,#columname,text)
NextSeek
PreviousSeek
and it would report the row number of the first hit it encounters!
BTW, I'm having a bit of trouble connecting to DB's (the example in PB only uses Opendatabaserequester, but i'm trying to connect directly, can you give a little help)
Kind Regards
Rui Carvalho
[DURON 1K - 256Mb - 40Gb - GFORCE MX2 64Mb - W2K PRO]
Hi Manolo,
These two commands would be usefull!
And also:
DatabaseSeek(#database,#Table,#columname,text)
NextSeek
PreviousSeek
and it would report the row number of the first hit it encounters!
BTW, I'm having a bit of trouble connecting to DB's (the example in PB only uses Opendatabaserequester, but i'm trying to connect directly, can you give a little help)
--Originally posted by Manolo
Hi Fred,
Is possible built two news commands for Database???
LastDatabaseRow --> acces to last register in one table.
SeekDatabaseRow --> acces to one especific register in one table.
Manolo
Kind Regards
Rui Carvalho
[DURON 1K - 256Mb - 40Gb - GFORCE MX2 64Mb - W2K PRO]
-
BackupUser
- PureBasic Guru
- Posts: 16777133
- Joined: Tue Apr 22, 2003 7:42 pm
Restored from previous forum. Originally posted by Rings.
And for a Recordpointer, like you want some (The Seek Stuff ), plz note:
This is a SQL Database based lib, never a Access or Dbase one.
You can add your own Recordpointer with a simple autoincrement long,
for example name the field 'NR' .
and always put a 'Select * from Tablename Where NR=xxx' in your SQL-Syntax.
So you can search and hangle through the records you want.
Its a long way to the top if you wanna .....CodeGuru
search the resourcesite for a Database-Example by me, i guess it handles that what you want.BTW, I'm having a bit of trouble connecting to DB's (the example in PB only uses Opendatabaserequester, but i'm trying to connect directly, can you give a little help)
And for a Recordpointer, like you want some (The Seek Stuff ), plz note:
This is a SQL Database based lib, never a Access or Dbase one.
You can add your own Recordpointer with a simple autoincrement long,
for example name the field 'NR' .
and always put a 'Select * from Tablename Where NR=xxx' in your SQL-Syntax.
So you can search and hangle through the records you want.
Its a long way to the top if you wanna .....CodeGuru
-
BackupUser
- PureBasic Guru
- Posts: 16777133
- Joined: Tue Apr 22, 2003 7:42 pm
Restored from previous forum. Originally posted by Manolo.
Ok Rings,
I tested you TestDB, but you acces to Acces is via DSN (ODBC driver or not) with one dll. No direct acces to database. You remember the olds filesystems??? DBase3 and 4, Clipper, C-Isam, D-Isam and others???. The calls to this filesystems is directly from commands, not via ODBC or DSN. My pretension not is 'go to de past', but is more eficiently and with more independent work with directly acces to databases that via ODBC or DSN.
In you want, please see the next web from HBasic http://hbasic.sourceforge.net/screensho ... db_connect
and for more explanation, please see: http://www.trolltech.com
In this cases is possible the direct acces to MySQL without DSN and ODBC.
My pretension for Fred is only the request for build 2 commands, only if this is possible, not obligation.
Sorry my frend por this very, very bad english.
Manolo
Ok Rings,
I tested you TestDB, but you acces to Acces is via DSN (ODBC driver or not) with one dll. No direct acces to database. You remember the olds filesystems??? DBase3 and 4, Clipper, C-Isam, D-Isam and others???. The calls to this filesystems is directly from commands, not via ODBC or DSN. My pretension not is 'go to de past', but is more eficiently and with more independent work with directly acces to databases that via ODBC or DSN.
In you want, please see the next web from HBasic http://hbasic.sourceforge.net/screensho ... db_connect
and for more explanation, please see: http://www.trolltech.com
In this cases is possible the direct acces to MySQL without DSN and ODBC.
My pretension for Fred is only the request for build 2 commands, only if this is possible, not obligation.
Sorry my frend por this very, very bad english.
Manolo
-
BackupUser
- PureBasic Guru
- Posts: 16777133
- Joined: Tue Apr 22, 2003 7:42 pm
Restored from previous forum. Originally posted by Num3.
I'm using your work to connect to databases, I still havent seen another way to do it.
Pretty slick stuff btw
I now working my way through the SQL syntax... I have the docs for it, but it will take some time to handle complex operations
Kind Regards
Rui Carvalho
[DURON 1K - 256Mb - 40Gb - GFORCE MX2 64Mb - W2K PRO]
I'm using your work to connect to databases, I still havent seen another way to do it.
Pretty slick stuff btw
I now working my way through the SQL syntax... I have the docs for it, but it will take some time to handle complex operations
--Originally posted by Rings
search the resourcesite for a Database-Example by me, i guess it handles that what you want.BTW, I'm having a bit of trouble connecting to DB's (the example in PB only uses Opendatabaserequester, but i'm trying to connect directly, can you give a little help)
And for a Recordpointer, like you want some (The Seek Stuff ), plz note:
This is a SQL Database based lib, never a Access or Dbase one.
You can add your own Recordpointer with a simple autoincrement long,
for example name the field 'NR' .
and always put a 'Select * from Tablename Where NR=xxx' in your SQL-Syntax.
So you can search and hangle through the records you want.
Its a long way to the top if you wanna .....CodeGuru
Kind Regards
Rui Carvalho
[DURON 1K - 256Mb - 40Gb - GFORCE MX2 64Mb - W2K PRO]
-
BackupUser
- PureBasic Guru
- Posts: 16777133
- Joined: Tue Apr 22, 2003 7:42 pm
Restored from previous forum. Originally posted by gnozal.
Wow !
If only the purebasic editor would look like this !
http://hbasic.sourceforge.net/screensho ... indow.html
Wow !
If only the purebasic editor would look like this !
http://hbasic.sourceforge.net/screensho ... indow.html
-
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?
God no!!!! (Said in an extremely panicky voice with visions of overcrowded and over complicated Visual Basic IDE in his head)Originally posted by gnozal
Wow !
If only the purebasic editor would look like this !
http://hbasic.sourceforge.net/screensho ... indow.html
Fangles woz ear orright den?
-
BackupUser
- PureBasic Guru
- Posts: 16777133
- Joined: Tue Apr 22, 2003 7:42 pm