Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums
Members
Pages
Search
Help
Register
Login
Home
Home
»
U++ Library support
»
U++ SQL
»
Issue with getting data back from a sqlite3 database
Show:
Today's Messages
::
Show Polls
::
Message Navigator
E-mail to friend
Issue with getting data back from a sqlite3 database
[
message #19644
]
Sat, 27 December 2008 13:48
BioBytes
Messages:
310
Registered:
October 2008
Location:
France
Senior Member
Hi all,
I wrote the following code which works when oepning and closing the sqllite3 database file :
if(deepSkySession.Open("deepSkyDB")){
deepMessageLbl.SetText("En consultation");
Sql sql(deepSkySession);
sql.Clear();
sql.Execute("select * from deepskygendata");
PromptOK(AsString(sql.GetColumns()));
}
else PromptOK("Impossible d'ouvrir la base de données");
}
but I did not recover data information as sql.getcolumns() returned 0.
I have built my database using Sqliteman software and when I built the query through Sqliteman I got the following syntax :
SELECT CONSNAME FROM "main"."deepskygendata";
How can I write the sql.execute(String str)so it goes right ?
Thanks in advance for help
Regards
Biobytes
Report message to a moderator
[
Message index
]
Issue with getting data back from a sqlite3 database
By:
BioBytes
on Sat, 27 December 2008 13:48
Re: Issue with getting data back from a sqlite3 database
By:
zsolt
on Sat, 27 December 2008 23:42
Re: Issue with getting data back from a sqlite3 database
By:
BioBytes
on Sun, 28 December 2008 09:22
Re: Issue with getting data back from a sqlite3 database
By:
zsolt
on Sun, 28 December 2008 10:49
Re: Issue with getting data back from a sqlite3 database
By:
BioBytes
on Sun, 28 December 2008 18:24
Previous Topic:
Convert String to SqlId
Next Topic:
How to use Sql * Update
Goto Forum:
- Community
U++ community news and announcements
PR, media coverage, articles and documentation
U++ Webs: Functioning, Layout , Design, Features and Structure of these forums, homepage etc.
Coffee corner
Newbie corner
U++ based job offers
- Developing U++
U++ Developers corner
External resources
Releasing U++
UppHub
Bugs (& fixes)
Documentation
U++ TheIDE and Library: Releases and ChangeLogs
Mac OS
Android
- U++ Library support
U++ Library : Other (not classified elsewhere)
U++ Core
Look and Chameleon Technology
U++ Libraries and TheIDE: i18n, Unicode and Internationalization
U++ SQL
U++ MT-multithreading and servers
U++ Callbacks and Timers
U++ Widgets - General questions or Mixed problems
TopWindow&PopUp, TrayIcon
Menus&Toolbars
StatusBar&InfoCtrl
Splitter
TabCtrl
Slider&ProgressIndicator
ArrayCtrl, HeaderCtrl & GridCtrl
TreeCtrl
RichText,QTF,RTF...
LineEdit, EditFields, DocEdit
Draw, Display, Images, Bitmaps, Icons
FileSel&FileList, Path
CalendarCtrl
Skylark
ScatterDraw & ScatterCtrl
Archive
- U++ TheIDE
U++ TheIDE: Other Features Wishlist and/or Bugs
U++ TheIDE: Compiling, Linking, Debugging of your packages
U++ TheIDE: Installation, Compiling and Running of theide
U++ TheIDE: CodeEditor, Assist++, Topic++
U++ TheIDE: Packages
U++ TheIDE: Layout (Forms) Designer
U++ TheIDE: Icon designer
- Extra libraries, Code snippets, applications etc.
U++ users applications in progress and useful code snippets, including reference examples!
U++ Esc Interpreter, Esc Macros and templates
U++ and AI
C++ language problems and code snippets
Applications created with U++
OS Problems etc., Win32, POSIX, MacOS, FreeBSD, X11 etc
-=]
Back to Top
[=-
[
Syndicate this forum (XML)
] [
] [
]
Current Time:
Tue Jun 24 13:33:34 CEST 2025
Total time taken to generate the page: 0.06451 seconds