I've upgraded from Valentina 6.3 to Valentina 9. I'm now seeing in the release notes the introduction of the ILIKE SQL keyword.
Previously, my app did all case insensitive searches. I'm now seeing that some searches are case sensitive. From wh...
wondering if it's possible to link the same table with binary link. The idea is a table with tasks and sometimes a task can be a subtask of a task in same table. Is a binary link an possible option for this relation? it's not urgent, just a t...
Hi Valentina Developers,
Now you can use in Valentina 6.0 a new powerful command 'MERGE'. This command is from SQL2003 standard.
This command allows you to combine by some logic INSERT, UPDATE, DELETE in the single command. On of the simplest ...
I realize I can update a record with an UPDATE sql command while another user has set a read and write lock on this record in a VCursor. Is it really the intended behavior ? Is the UPDATE sql command a "NoLock" command ?...
Hi, is a sql select always performed against a database, or can I do a new selection inside the returned cursor.
Problem is: I have a search field, doing query to my db as you type, and this text is used in my query to the DB, this is then populat...
Got a bit of an edge case for sorting. The sorting works in Xojo, but not quite in Valentina.
The data is similar to:
Now if the data is
sorting doesn't work. a:::b:::c should be followi...
Hi, a simple group by question.
How to I get a table to group by month when having a dato field...
SELECT COUNT(*), month(dato) AS MND
GROUP BY month(dato)
will not work because I'm not allowed to use expressions in group by......
Hi, I want to make a more google like search.
What ever is in input text I want it to search in all fields in my cursor. But I don't want to write all the fields in my WHERE LIKE.
So how do I do:
Select field1, field2, .... field12