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 #54966 is a reply to message #54886]

Fri, 02 October 2020 11:40

mirek is currently offline

mirek
Messages: 14265
Registered: November 2005

Ultimate Member

I have looked through the code and I am impressed, you got it almost all right in really record time!

Some tidbits:

	SQL * Select(dlg.ctrls).From(LINEITEMS).Where(LINEITEM_ID == idNum);

Using SQL for Select with Fetch loop is possible but not quite recommended (mostly on past experience, I have shoot my leg several times here Smile

Smile

. The problem is that very often your Fetch loop will call some routine and that routine will use SQL for something else (e.g. Update or another Select) and that will erase the current resultset... Better declare Sql sql and fetch from this.

Note that usage like SQL % Select ... (selecting single value from single line, no fetching) is still fine.

Value ConvLineItemCls::Scan ( const Value &q ) const

I see that you have not used it afterwards, but anyway... Scan is supposed to convert from "display" format - usually text - to Value. Your usage seems exactly opposite. I guess it should have been Format here (format from Value to usually text).

SQL & ::Insert(LINEITEMS)

Sql::operator& is deprecated. It makes the statment throw exception, but that approach was not quite as useful as it seemed. Use * and test for error aftewards...

Mirek

[Updated on: Fri, 02 October 2020 11:40]

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 10:46:59 CEST 2025

Total time taken to generate the page: 0.04011 seconds