Devart Forums

I have a user defined function (defined using registerfunction) that returns a formatted string based on certain parameters that are passed to the function.

I can check the parameters and return an error string, on each iteration of the function, if a paramter is incorrect but I would rather abort the query at the first error and let my calling application provide a more comprehensive help message. Is this possible?

Thank You

All seems OK now thank you.

Thank you - got the email an hour ago

Hi Maxim

I filled in the form yesterday as requested, but have not received the night build yet. How do I get this?

The next stage of my development requires this fix so everything is on hold here

Cheers
Paul

Hi Maxim

Thank You for fixing this so promptly.

I have provided the details asked for via the support link.

Cheers

Thank You Maxim

I look forward to receiving a fix

Hi Maxim

Thank You

I have sent a sample simple project via the link (and sent the same by email on Friday afternoon last week).

Please let me know if there is anything else I can do

Paul

I am having problems adding a calculated field to a query at run time

The following query fails with an exception
However if I do not add the additional integer field, and just execute the query it runs OK.
Obviously I need to provide a value for the id field in OnCalcfields - but there is something else I am doing wrong

I am probbaly being dull but i cannot find any documentationon the smart refresh feature - could someone please point me in the direction of it.

Other than how to use it I am interested in any limitations on its use.

Thanks

Hi Maxim

The issue is sorted - but everything you need to recreate the issue was in my initial post.

It's a three line program

Thank you - that worked

Hi

Using UniDac SQLite with Builder XE3

Table with schema

CREATE TABLE unix10and13 (dt int)

with the data as below:
1234345087123

The following query causes an invalid floating point operation exception

UniQuery1->SQL->Clear();
UniQuery1->SQL->Add("select DateTime(unix10and13.dt, 'unixepoch') AS converted FROM unix10and13");
UniQuery1->Execute();

with the data as below the same query works fine.:
1234345087

In an SQLite shell the same query produces an erroneous date but does not cause an error

sqlite> select * from unix10and13;
1234345087123
sqlite> select DateTime(unix10and13.dt, 'unixepoch') AS converted FROM unix10and13;
-1413-03-01 13:07:12

This occurs in 6.4.14, 6.1.3 and 5.5.11

Thank You

Thanks for the feedback Alex.

Yes the issue with multiple data types in the same column is my problem and I do see it in third party databases.

I think I see what you are getting at. But if using your test data set I loop through each row using

Variant v;

while(!UniQuery1->Eof)
v=UniQuery1->FieldByName("test")->AsVariant;
UniQuery1->Next()

Then I can get at the correct value for each row as a variant in v

so is it not possible to update your Dac such

while(!UniQuery1->Eof)
v=UniQuery1->FieldByName("test")->AsVariant;
t=UniQuery1->FieldByName("test")->AsRawType;
UniQuery1->Next()

such that ->AsRawType returns the correct storage type used by SQLite?

Thanks Alex, that is correct and it is entirely the point of my request

While you can set a user type the underlying type, as returned by the sqlite function typeof(my_type1), is one of just 5 basic types that sqlite supports.

It is the basic underlying type that SQ:Lite chooses to store the data at a binary level that i am interested in. If I was not using UniDac but was using the SQLite library then I can get at this data using typeof(x).

It is this additional functionality that I need.

Hi Alex

The functionality I am suggesting is something along the lines of adding to the functionality of TUniQuery to allow me to a) determine what data type SQLite is actually using to store a particular value and b) get the correspondin value as a Variant.

so, one idea would be a function:

UniQuery->FieldByName("somefield")->GetRawType()

which would return either a string or better an integer that represented the type of data. The corrresponding function in SQLite is:

typeof(X) - The typeof(X) function returns a string that indicates the datatype of the expression X: "null", "integer", "real", "text", or "blob".

I would then need an associated function

UniQuery->FieldByName("somefield")->GetRawValue()

That would return a Variant with the value from the field, based on the type returned by GetRawType I could then take whatever action is appropriate with the Variant.

All of this would need to work irrespective of any DataTypeMapping rules and should allow me to detect any fields where someone has taken advantage of SQLites loose type affinity rules.

This is of course my suggestion of a way to resolve this - you may have a better idea

Thank You