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 #55005 is a reply to message #54819]

Sun, 04 October 2020 17:27

jimlef is currently offline

jimlef
Messages: 90
Registered: September 2020
Location: US

Member

Again, Thank you Mirek!
Quote:

Sometimes it is worth providing IDs even if you are not directly dealing with SQL, leads to cleaner code

arrayLineItems.AddColumn(DESCRIPTION, "Description", 80);
....
(DESCRIPTION, arrayLineItems.GetColumn(i,DESCRIPTION))

Only one issue when I implement these, I keep getting:

102	if (optCustTaxable.Get() == true && arrayLineItems.GetColumn(i, ISTAXABLE)  == 1) {
103	     taxable = round((double)arrayLineItems.GetColumn(i, PRICE) * (double)arrayLineItems.GetColumn(i, QTY), 2);

/home/james/upp/MyApps/Invoices/UI/CreateInvoice.cpp (102): error: no viable conversion from 'Upp::SqlId' to 'int'
/home/james/upp/MyApps/Invoices/UI/CreateInvoice.cpp (103): error: no viable conversion from 'Upp::SqlId' to 'int'
...
/home/james/upp/MyApps/Invoices/UI/CreateInvoice.cpp (171): error: no viable conversion from 'Upp::SqlId' to 'int'

Every GetColumn call in the code generates this error?

Jim

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: Sun Aug 24 12:24:53 CEST 2025

Total time taken to generate the page: 0.04626 seconds