I would like to write in SQLite with AcuCobol 9.2.5 and use sqlite3.dll. Is it possible and when yes, where can I find an example?
Thank you in advance.
Werner
Access to SQLite with AcuCobol 9.2
I would like to write in SQLite with AcuCobol 9.2.5 and use sqlite3.dll. Is it possible and when yes, where can I find an example?
Thank you in advance.
Werner
For mssql you can use this code, for sqllite may be the same, only the connectstring must be other:
see zip-file
I would like to write in SQLite with AcuCobol 9.2.5 and use sqlite3.dll. Is it possible and when yes, where can I find an example?
Thank you in advance.
Werner
move 'ODBC;DSN=msaccess;database=FDARTSTA;Uid=Admin;Pwd;' to sql-connectstring
SQLITE is nearly the same!
I would like to write in SQLite with AcuCobol 9.2.5 and use sqlite3.dll. Is it possible and when yes, where can I find an example?
Thank you in advance.
Werner
https://sqlite.org/index.html
Vielen Dank für die Antwort und die Datei. Ich werde diese morgen testen.
In einem Beitrag habe ich diesen Ansatz über die sqlite3.dll gefunden und eingebaut:
call "sqlite3_exec" using by value sqlite3-db
by reference sqlQuery
by value 0
by value 0
by reference err-msg
returning RC
end-call.
Das Schreiben in die SQlite-DB-Tabelle und das Löschen der Daten funktioniert so. Nur Retour-Werte kann ich nicht auswerten. Offenbar funktioniert dieser Aufruf nur in eine Richtung.
Vielen Dank für die Antwort und die Datei. Ich werde diese morgen testen.
In einem Beitrag habe ich diesen Ansatz über die sqlite3.dll gefunden und eingebaut:
call "sqlite3_exec" using by value sqlite3-db
by reference sqlQuery
by value 0
by value 0
by reference err-msg
returning RC
end-call.
Das Schreiben in die SQlite-DB-Tabelle und das Löschen der Daten funktioniert so. Nur Retour-Werte kann ich nicht auswerten. Offenbar funktioniert dieser Aufruf nur in eine Richtung.
Hi Werner,
you must become the result code (RC) in the field RC, rc=0 will be succesfull, otherwise error.
you must call to begin of your Programm: call "sqlite3.dll"
Can you share your Little program, i have many time and will help you to include all SQL possibilities as for other database as mssql, mysql, Oracle, db2 and other.
Thank you for giving us the possibility to help you and the community
Hi Werner,
you must become the result code (RC) in the field RC, rc=0 will be succesfull, otherwise error.
you must call to begin of your Programm: call "sqlite3.dll"
Can you share your Little program, i have many time and will help you to include all SQL possibilities as for other database as mssql, mysql, Oracle, db2 and other.
Thank you for giving us the possibility to help you and the community
writing works well, also delete, open and close. Just reading ist not possible.
I don't get a return and RC is not zero. I think the data types are wrong with USING BY. I also do not recognize in which field / table the return values would be output.
Hi Werner,
you must become the result code (RC) in the field RC, rc=0 will be succesfull, otherwise error.
you must call to begin of your Programm: call "sqlite3.dll"
Can you share your Little program, i have many time and will help you to include all SQL possibilities as for other database as mssql, mysql, Oracle, db2 and other.
Thank you for giving us the possibility to help you and the community
here a example to read a database with mssql (see attachment)
Vielen Dank für die Antwort und die Datei. Ich werde diese morgen testen.
In einem Beitrag habe ich diesen Ansatz über die sqlite3.dll gefunden und eingebaut:
call "sqlite3_exec" using by value sqlite3-db
by reference sqlQuery
by value 0
by value 0
by reference err-msg
returning RC
end-call.
Das Schreiben in die SQlite-DB-Tabelle und das Löschen der Daten funktioniert so. Nur Retour-Werte kann ich nicht auswerten. Offenbar funktioniert dieser Aufruf nur in eine Richtung.
with "sqlite3_exec" there will be a procedure that is call, this is possible with all database and you must know what is describe in this _exec!
here a example to read a database with mssql (see attachment)
Thank you very much. How can I use this code in AcuCobol 9.2?
EXEC SQL doesn't workDu you have a complete sample I can test in AcuBench, please?
I would like to write in SQLite with AcuCobol 9.2.5 and use sqlite3.dll. Is it possible and when yes, where can I find an example?
Thank you in advance.
Werner
Werner, it exist a odbc Driver for sqlite and then you can use normal SQL commands,
see https://www.devart.com/odbc/sqlite/download.html
writing works well, also delete, open and close. Just reading ist not possible.
I don't get a return and RC is not zero. I think the data types are wrong with USING BY. I also do not recognize in which field / table the return values would be output.
Driver=Devart ODBC Driver for SQLite;Database=p:\\cobol\\sqlite\\sqlite3.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;Force Create Database=True;
This must run with acucobol, my example run with netexpress 5.x and Visual Cobol 5.x
writing works well, also delete, open and close. Just reading ist not possible.
I don't get a return and RC is not zero. I think the data types are wrong with USING BY. I also do not recognize in which field / table the return values would be output.
Otherwise you become not the fully return code!
in wich variables do you become the select fields?
Werner, i have a running Version with full functionality via odbc driver, here a possible connectstring:
Driver=Devart ODBC Driver for SQLite;Database=p:\\cobol\\sqlite\\sqlite3.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;Force Create Database=True;
This must run with acucobol, my example run with netexpress 5.x and Visual Cobol 5.x
Driver=Devart ODBC Driver for SQLite;Database=p:\\cobol\\sqlite\\sqlite3.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;Force Create Database=True;
This must run with acucobol, my example run with netexpress 5.x and Visual Cobol 5.x
Thank you once more. I'll test the ODBC-Version with AcuCobol 10.3 in some days. Up to now I'm using the DLL-Access.
Thank you once more. I'll test the ODBC-Version with AcuCobol 10.3 in some days. Up to now I'm using the DLL-Access.
Is it not necessary to upload a full working example for sqlite?
The ODBC-Driver will cost 150$
Thank you very much. How can I use this code in AcuCobol 9.2?
EXEC SQL doesn't workDu you have a complete sample I can test in AcuBench, please?
If you are using EXEC SQL within your Acu COBOL program, in addition to the regular compiler and runtime, you need to have the AcuSQL PreCompiler and AcuSQL runtime installed
Recent badge winners
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
