U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » Community » Newbie corner » sqlarray and sqlite (Trying to use sqlite example but...)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Re: sqlarray and sqlite [message #54852 is a reply to message #54851]

Tue, 22 September 2020 09:08

mirek is currently offline

mirek
Messages: 14265
Registered: November 2005

Ultimate Member

Your .sch creates

SqlId CUSTOMERS("CUSTOMERS");

struct S_CUSTOMER {
.....
};

SetTable obviously needs CUSTOMERS as parameter....

Additional suggestion: CustArray is SqlArray, right? In that case it is better to leave fetching the data to

CustArray.Query();

You can also add where condition e.g.:

CustArray.Query(EMAIL == "smith@email.com");

Sql sql(sqlite3);

You do need to specify the session here, as you have assigned a global default session by

SQL = sqlite3;

And it is better to avoid text SQL commands with SqlExp:

	sql.Execute("select * from CUSTOMERS");

sql * SelectAll().From(CUSTOMERS);

see https://www.ultimatepp.org/src$Sql$SqlExp_en-us.html

This way your commands get at least partially checked by C++ compiler and more importantly it avoids SQL injection problem.

Mirek

Report message to a moderator

Send a private message to this user

[Message index]

		sqlarray and sqlite By: jimlef on Fri, 18 September 2020 22:49
		Re: sqlarray and sqlite By: jimlef on Sat, 19 September 2020 05:50
		Re: sqlarray and sqlite By: jimlef on Sat, 19 September 2020 06:57
		Re: sqlarray and sqlite By: jimlef on Sat, 19 September 2020 08:04
		Re: sqlarray and sqlite By: mirek on Mon, 21 September 2020 08:19
		Re: sqlarray and sqlite By: jimlef on Mon, 21 September 2020 22:54
		Re: sqlarray and sqlite By: jimlef on Tue, 22 September 2020 03:05
		Re: sqlarray and sqlite By: mirek on Tue, 22 September 2020 09:08
		Re: sqlarray and sqlite By: jimlef on Tue, 22 September 2020 17:43
		Re: sqlarray and sqlite By: mirek on Tue, 22 September 2020 17:54
		Re: sqlarray and sqlite By: jimlef on Tue, 22 September 2020 18:07
		Re: sqlarray and sqlite By: mirek on Tue, 22 September 2020 18:47
		Re: sqlarray and sqlite By: jimlef on Tue, 22 September 2020 20:41
		Re: sqlarray and sqlite By: mirek on Wed, 23 September 2020 16:32
		Re: sqlarray and sqlite By: jimlef on Wed, 23 September 2020 17:14
		Re: sqlarray and sqlite By: jimlef on Wed, 23 September 2020 19:57
		Re: sqlarray and sqlite By: jimlef on Thu, 24 September 2020 06:08
		Re: sqlarray and sqlite By: mirek on Thu, 24 September 2020 13:46
		Re: sqlarray and sqlite By: jimlef on Thu, 24 September 2020 16:40
		Re: sqlarray and sqlite By: jimlef on Thu, 24 September 2020 19:28
		Re: sqlarray and sqlite By: mirek on Fri, 02 October 2020 11:40
		Re: sqlarray and sqlite By: jimlef on Fri, 02 October 2020 15:13
		Re: sqlarray and sqlite By: jimlef on Sat, 03 October 2020 00:17
		Re: sqlarray and sqlite By: mirek on Sun, 04 October 2020 10:05
		Re: sqlarray and sqlite By: jimlef on Sun, 04 October 2020 17:27
		Re: sqlarray and sqlite By: mirek on Sun, 04 October 2020 19:56
		Re: sqlarray and sqlite By: jimlef on Sun, 04 October 2020 20:37

Previous Topic:	Friends? Cousins? Half-siblings?
Next Topic:	how to make an editfield accept only number or date? have any examples in the documentation?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sat Jul 05 15:46:14 CEST 2025

Total time taken to generate the page: 0.03382 seconds