Get Tablenames out of an database(ODBC-Connection)

Got an idea for enhancing PureBasic? New command(s) you'd like to see?
BackupUser
PureBasic Guru
PureBasic Guru
Posts: 16777133
Joined: Tue Apr 22, 2003 7:42 pm

Post by BackupUser »

Restored from previous forum. Originally posted by Rings.

If we can get all tablenames in a odbc-connection (Enum Tables)i were totaly happy and can write generic database-importer.
I know that there must be a way in the odbc32.dll .

Its a long way to the top if you wanna .....CodeGuru
BackupUser
PureBasic Guru
PureBasic Guru
Posts: 16777133
Joined: Tue Apr 22, 2003 7:42 pm

Post by BackupUser »

Restored from previous forum. Originally posted by ebs.

Rings,

There is an example of using the ODBC API at: http://support.microsoft.com/support/kb ... 4.asp?FR=0

It's for Visual Basic, but it shouldn't be too hard to convert, since it mostly uses the API functions.

Eric

If we can get all tablenames in a odbc-connection (Enum Tables)i were totaly happy and can write generic database-importer.
I know that there must be a way in the odbc32.dll .

Its a long way to the top if you wanna .....CodeGuru
BackupUser
PureBasic Guru
PureBasic Guru
Posts: 16777133
Joined: Tue Apr 22, 2003 7:42 pm

Post by BackupUser »

Restored from previous forum. Originally posted by Rings.

Its an VB-examples and uses RDO, but only for a handle(hDBC) to an opened Connection.
with a few asm-lines i have now these handle too and can implement the needed feature by my own.thx.

Its a long way to the top if you wanna .....CodeGuru

Edited by - Rings on 18 August 2002 08:22:48
BackupUser
PureBasic Guru
PureBasic Guru
Posts: 16777133
Joined: Tue Apr 22, 2003 7:42 pm

Post by BackupUser »

Restored from previous forum. Originally posted by Rings.

Just to remember, i want that feature as a native(s) commands

Its a long way to the top if you wanna .....CodeGuru
BackupUser
PureBasic Guru
PureBasic Guru
Posts: 16777133
Joined: Tue Apr 22, 2003 7:42 pm

Post by BackupUser »

Restored from previous forum. Originally posted by MrVainSCL.

Hi @ all
If someone could post a working example how to load/save/create an xls file and how to read/write datas to it, plase inform me! Normaly i need such a routine for a program that will be in action this week on a big mess... (the company where i learn a new job atm)!

But i think i will load/save the mess datas in a normal textfile! The company is not really happy about this, but better to save datas in a textfile as no program and no data :wink:)

Many many thanks in advance for any working examples!

PIII450, 256MB Ram, 80GB HD + 6,4 GB, RivaTNT, DirectX8.1, SB AWE64, Win2000 + all Updates...

greetz
MrVainSCL! aka Thorsten
BackupUser
PureBasic Guru
PureBasic Guru
Posts: 16777133
Joined: Tue Apr 22, 2003 7:42 pm

Post by BackupUser »

Restored from previous forum. Originally posted by Danilo.

what a mess... LOL
BackupUser
PureBasic Guru
PureBasic Guru
Posts: 16777133
Joined: Tue Apr 22, 2003 7:42 pm

Post by BackupUser »

Restored from previous forum. Originally posted by MrVainSCL.

Hi Danilo
If you dont want help me (and maybe other guys!?) on the irc nor here on the forum, you can save your comments!

PS: As you sayed on the IRC you would be perfect! Note: NOBODY IS PERFECT! No more comments...

PIII450, 256MB Ram, 80GB HD + 6,4 GB, RivaTNT, DirectX8.1, SB AWE64, Win2000 + all Updates...

greetz
MrVainSCL! aka Thorsten
BackupUser
PureBasic Guru
PureBasic Guru
Posts: 16777133
Joined: Tue Apr 22, 2003 7:42 pm

Post by BackupUser »

Restored from previous forum. Originally posted by Berikco.

mess messe



Regards,

Berikco

http://www.benny.zeb.be
BackupUser
PureBasic Guru
PureBasic Guru
Posts: 16777133
Joined: Tue Apr 22, 2003 7:42 pm

Post by BackupUser »

Restored from previous forum. Originally posted by Danilo.

MrVain:
You know yourself you post mostly senseless sh*t here.
Maybe you are tired... whatever (not our problem),
but you should THINK before posting.

6 new entries in bug-reports which are mostly
totally nonsense. Writing numbers in strings..
this are mistakes that 12 years old kids do,
not 30 years old "professional":) coders.

All this is just funny so everybody can see
you are the forum clown.
Better slow down a bit, TAKE A REST and
THINK before posting.

cya,
...Danilo

(registered PureBasic user)
BackupUser
PureBasic Guru
PureBasic Guru
Posts: 16777133
Joined: Tue Apr 22, 2003 7:42 pm

Post by BackupUser »

Restored from previous forum. Originally posted by fweil.

Have a look there viewtopic.php?t=1779

MrVain is not 30 ... close to but not 30.

:)


Francois Weil
14, rue Douer
F64100 Bayonne
BackupUser
PureBasic Guru
PureBasic Guru
Posts: 16777133
Joined: Tue Apr 22, 2003 7:42 pm

Post by BackupUser »

Restored from previous forum. Originally posted by Franco.

Please calm down...

Have a nice day...

Franco
BackupUser
PureBasic Guru
PureBasic Guru
Posts: 16777133
Joined: Tue Apr 22, 2003 7:42 pm

Post by BackupUser »

Restored from previous forum. Originally posted by Rings.

and do not forget the topic :)

Its a long way to the top if you wanna .....CodeGuru
Post Reply