On 2/7/2010 12:26 AM, Drew Jensen wrote:
Last update for tonight. (new file attached)
But not quite last question.
Just tried this with SQLite3 ODBC data source.
Fail with error '?' in SQL INSERT not recognized.
We do support prepared statements with parameters under SQLite3 ODBC, yes?
Thank
Last update for tonight. (new file attached)
Added MySQL native connector check, support
As long as the form is based on a table in the schema (catalog) used
when the connection was established, it seems to work.
Drew
On 2/6/2010 11:35 PM, Drew Jensen wrote:
A quick fix - attached is a new v
Hi,
Specifically the updateSchema name.
The property at the dataform returns a null string.
The SQLQueryCompoers doesn't seem to have a way.
Am I missing something ovious?
For example the insert routines attached to another email work if I
include the schema name in the INSERT statement.
Bui
A quick fix - attached is a new version with
a fix to allow forms with things like buttons ;>)
Also - tried this with MySQL Native Connecter and it kind of works, kind
of doesn't...
next email with the question on that.
Thanks
On 2/6/2010 9:35 PM, Drew Jensen wrote:
Hi,
Attached is a sma
Hi,
Attached is a small basic module.
If you would be willing to hep me check it out:
Import the bas file into a basic library embedded in an ODB file - will
not work as a stand alone Basic library
Create a form with the Property Insert Data Only true.
You should make sure the dataform Cycle
and as a BTW
if CurrentControl.ServiceName =
"stardiv.one.form.component.ImageControl" then
dim oStream as object
oStream = CurrentControl.BoundField.getBinaryStream
prepStatement.setBinaryStream( fldcnt, oStream, oStream.Length )
else
prepStatement.setString( fldcnt,
Curren
That is the error I get with the follow lines:
if CurrentControl.ServiceName =
"stardiv.one.form.component.ImageControl" then
prepStatement.setBlob( fldcnt, CurrentControl.BoundField.getBlob )
else
prepStatement.setString( fldcnt,
CurrentControl.BoundField.getString )
end if
Thi
