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 » SQLITE3: Bind parameter by name
Re: SQLITE3: Bind parameter by name [message #26722 is a reply to message #26718] Fri, 21 May 2010 12:31 Go to previous messageGo to previous message
tojocky is currently offline  tojocky
Messages: 607
Registered: April 2008
Location: UK
Contributor

frankdeprins wrote on Fri, 21 May 2010 10:06

Hello,

I have a question related to this as well.
I am creating a database tool for sqlite where the user can launch arbitrary statements and, before executing them, I have to check whether there are bind variables (and how many).
As you say, the interface of the Sql class is quite general and this seems to be lacking.
I tried the ParseForArgs function by copying it in my sources, but it is not really fool proof, as it does not take comments in the statement in account.
e.g. the function returns 1 for this statement:
select 
  field -- just some field or not?
from
  table

although the '?' in this case is not really a bind variable.

Any suggestions?

frank


To be sure, remove comments form sql statement!
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks
Next Topic: Oracle8: Insert a long RAW Value
Goto Forum:
  


Current Time: Fri Jul 04 23:05:19 CEST 2025

Total time taken to generate the page: 0.03751 seconds