[dba-dev] Re: Allow controls after last data control ( was Re: Anyone willing to give this function a try and let me know)

2010-02-06 Thread Drew Jensen
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

[dba-dev] Re: Allow controls after last data control ( was Re: Anyone willing to give this function a try and let me know)

2010-02-06 Thread Drew Jensen
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

[dba-dev] How to find the Schema name from a dataform using the MySQL native connector?

2010-02-06 Thread Drew Jensen
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

[dba-dev] Allow controls after last data control ( was Re: Anyone willing to give this function a try and let me know)

2010-02-06 Thread Drew Jensen
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

[dba-dev] Anyone willing to give this function a try and let me know

2010-02-06 Thread Drew Jensen
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

[dba-dev] SetBlob.... ( was Re: setBlog not implemented for preparedStatement in HSQLdb SDBC driver)

2010-02-06 Thread Drew Jensen
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

[dba-dev] setBlog not implemented for preparedStatement in HSQLdb SDBC driver

2010-02-06 Thread Drew Jensen
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