2 posts in this topic
SQL lack of knowledge
maybe some of you can help me. I manage to connect with sql database and use a variable to search for different things when i do the select from database. My problem is that i'm reading the database with an MsgBox to see the values. But sometimes for the thing i'm filtering the dabase for it shows me different values and i only one to select one of it and move forward with my script. Is there any chance to read the database...view it...and in front of each value to have a thick box to select with value i want for the line.
After i select the the line value i want to stock the values from each column in different variables and then i want to send them as values to write in another database.
Is this possible?
Hope any of you can help me in this matter
ADO.au3 UDF - BETA - Support Topic
I want to present BETA Version of my ADO.au3 UDF.
This is modifed version of _sql.au3 UDF.
For that I want to thanks : ; Chris Lambert, eltorro, Elias Assad Neto, CarlH
This is first public release , and still is as BETA
DOWNLOAD LINK (in download section):
Below some interesting topics about databases:
For more info about ADO look here:
How to view only rows with duplicate values in a table
Referring to a question posted here, this is a possible SQL query that should do:
supposed you have an sqlite table named 'multimedia' with a column named 'sha1_hash', and you want to see only rows with the 'sha1_hash' value that appears more than one time within the table, you could use an SQL query like this:
SELECT sha1_hash, COUNT(sha1_hash) AS sha1_sum FROM multimedia GROUP BY sha1_hash HAVING sha1_sum>1 ORDER BY sha1_sum DESC; this query should show only records with the value of sha1_hash that appears more times also in other records, showing it only one time, with a column indicating how many occurrences are present, ordered from the most recurring to the least recurring one.
I don't know if this query can be simplified a bit...?,
.... if there is a simpler way I would like some hint,
Best way to store Dates in SQLite?
I ask for generic advice on what field format is best to use to store dates in a database (SQLite).
if is a better choice to stored separately year, month and day into 3 separate fields or use one field for a complete date-time group?
I have to store information of this kind:
a person is assigned to a job for a certain day (one day only)
a person is assigned to a job from a day to another day (a range of days)
then i have to query the database for a certain day so to know who is working to a certain job in a specific day.
Well, in the case of ranges of days (for example Mr. Bean works to JOB1 from May/15 to May/20) I have to store one record for each day of the range (6 record in this case) or use only one record with both dates in 2 fields of the same record?
the SQL query should 'ask' who is working on a specific day (even for days in the middle of the ranges).
My doubt is, what's the best way to store ranges of dates (as in the above example), so to be facilitated in the retrieval of those informations.
I'm afraid I'm not been clear, even if I did my best to be, anyway .... any suggestion is welcome..
PostgreSQL Video tutorials
Currently I'm working on MS SQL >> PostgreSQL migration.
Here are some of interesting Video tutorials about PostgreSQL