Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » I am trying to have two sqls one to read another to write
I am trying to have two sqls one to read another to write [message #46233] Wed, 30 March 2016 21:29 Go to next message
aftershock is currently offline  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.
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 Go to previous messageGo to next message
aftershock is currently offline  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?
Re: I am trying to have two sqls one to read another to write [message #46236 is a reply to message #46234] Thu, 31 March 2016 13:50 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
Hard to say without seeing the code...
Re: I am trying to have two sqls one to read another to write [message #46239 is a reply to message #46236] Thu, 31 March 2016 20:55 Go to previous message
aftershock is currently offline  aftershock
Messages: 143
Registered: May 2008
Experienced Member
mirek wrote on Thu, 31 March 2016 13:50
Hard to say without seeing the code...


I have no longer have a problem. Just asking.

I read here that you mirek does not advice using fetches.
What do you suggest using instead of them?

Previous Topic: GUID column in DB and SqlArray
Next Topic: Sqlite and DUAL_PRIMARY_KEY
Goto Forum:
  


Current Time: Fri Mar 29 07:12:54 CET 2024

Total time taken to generate the page: 0.01436 seconds