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 #26718 is a reply to message #26666] Fri, 21 May 2010 09:06 Go to previous messageGo to previous message
frankdeprins is currently offline  frankdeprins
Messages: 99
Registered: September 2008
Location: Antwerp - Belgium
Member
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
 
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: Mon Jul 07 01:36:33 CEST 2025

Total time taken to generate the page: 0.04222 seconds