PureBasic Forums - English

thanks for the quick reply! for my program its ok that i can give back only one value.

i just was not able to find this ProcedureReturn in the pb-help.

kimio

hello!

is there anyone who can tell me how to give back values from an pb.dll?

no problem to send values to my pb.dll - but how can i send parameters back? (like: return_values(1,2,"hallo",etc.)

ProcedureDLL MyFunction(in_value.l)
MessageRequester("Hello", Str(in_value), 0)
...
operations ...

ok....
my ODBC looks like:

DSN (data source name): kv (excel-table='kv.xls'; sheet='Tabelle1', i use excel 2000)

version: excel 97-2000

path to excel-folder: ok

write protected

look at my example on top: the database-connection is opened correctly (sub open_db:), i get no error-message.

can ...

thanks a lot!

ok, the SELECT statement has to be written in upper cases....

and the statement doesnt need a $ behind 'tabelle1'. this is because the whole query is a string, so you dont have to use a '$' behind the table-name (i have also tried it with $ behind tabelle1).

my query still does not ...

hello!

i am just trying to read an excel-sheet (name: "kv.xls", first table = "Tabelle1" ) (MS office 2000), but it does not work.

i can open the 'database', but my select-query is not accepted.

is there anyone who has an idea?

thanks a lot!

kimio ...

ok, it works!

here is the full code.

----------------------------------------

InitDatabase()
DriverODBC.s = "billing" ; change here !
If ExamineDatabaseDrivers()
While NextDatabaseDriver()
If DatabaseDriverName() = DriverODBC
Base_OK.b = 1
EndIf
Wend
EndIf
If Base_OK = 0 ...

ok...i have tried everything, but it still does not work. the programm does not find the ODBC-driver.

->@gnozal: DriverODBC.s = "MySQL" ; change here !

in my ODBC-DSN-Information the description is "MySQL ODBC 3.51 Driver DSN". the change to this description does also not work. ( i am working ...

i have a slight problem:

i just want to set up a connection from my PB-programm to a local mysql-database (mysql vers. 4.0; myODBC aktual version).

i dont want to use the OpenDatabaseRequester, because i want to open only one specific database.

my database connection parameters are:

ODBC ...