Pelles C forum

C language => User contributions => Topic started by: TimoVJL on November 16, 2015, 10:56:18 AM

Title: Simple DlgTestSQL example
Post by: TimoVJL on November 16, 2015, 10:56:18 AM

Simple DlgTestSQL example for generating CREATE TABLE clause.

EDIT 2015-11-18. fix column width change.

Title: Re: Simple DlgTestSQL example
Post by: jj2007 on November 17, 2015, 06:33:49 AM

Looks interesting, Timo, but what is it supposed to do? SaveLines doesn't appear to save something, and I only get this odd MessageBox...

Title: Re: Simple DlgTestSQL example
Post by: TimoVJL on November 17, 2015, 11:26:57 AM

You found a bug ;) Missing type for field. There isn't any checks yet.

This is a test bed for that dialog.
function SaveLines just create SQL-clause for SQLite.
Further processing is up to use/user.

Title: Re: Simple DlgTestSQL example
Post by: jj2007 on November 17, 2015, 12:01:03 PM

Alright, thanks. I was hoping to see a crispy example ;-)

Right now, a not-so-professional postal packet delivery site gave me "Error displaying the error page: Application Instantiation Error: Could not connect to MySQL." 8)

Title: Re: Simple DlgTestSQL example
Post by: TimoVJL on November 17, 2015, 05:24:45 PM

I can't recreate that error in your picture :(
What OS your use?

What kind of 'crispy' example do you mean?

Title: Re: Simple DlgTestSQL example
Post by: jj2007 on November 19, 2015, 02:56:47 AM

Quote from: TimoVJL on November 17, 2015, 05:24:45 PM

I can't recreate that error in your picture :(
What OS your use?

What kind of 'crispy' example do you mean?

Win7-64. And I meant just a "hello world"-style example. But I found one from Iczelion here (http://win32assembly.programminghorizon.com/odbc5.html).

Title: Re: Simple DlgTestSQL example
Post by: TimoVJL on November 19, 2015, 08:57:35 AM

ODBC tutorial here (http://www.easysoft.com/developer/languages/c/odbc_tutorial.html)
ODBC GUI shell is here (http://forum.pellesc.de/index.php?topic=3110.msg21897#msg21897)
SQLite3 GUI shell is here (http://forum.pellesc.de/index.php?topic=3110.msg21897#msg21897)