U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » I am trying to have two sqls one to read another to write

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

I am trying to have two sqls one to read another to write [message #46233]

Wed, 30 March 2016 21:29

aftershock
Messages: 143
Registered: May 2008

Experienced Member

Hi,
I use sqlite . I tried to use two sqls. one to read a table.. another sql to write another table.
I use fetch to get rows one by one for sql1.

However, fetch keeps resetting or losing its position as I used the second sql
(for second sql I try to create it from another session , that did help..)

How do you do this without fetch? Or how can I use two independent sql so they can fetch independently and not avoid influencing each other.

a.

Report message to a moderator

Re: I am trying to have two sqls one to read another to write [message #46234 is a reply to message #46233]

Wed, 30 March 2016 22:51

aftershock
Messages: 143
Registered: May 2008

Experienced Member

NO problem... It worked...even with just two sqls with the same session.
No problem with fetches.
It was a program bug.
I still wonder what is the problem with fetches? and what should be the replacement?

Report message to a moderator