When you have the map image and a DB with the correct associations, you can switch the "mode" to "show" (as by. The Map "creation mode" : you provide a map image and you start to pick up colors, set "upper level" region/state, and by clicking on a region you fill it and you name it, and all the data are saved on a sqlite DB (auto-created) It's all based on this thread and this other thread. gif tested) and filling them with colors, writing down a sqlite database to associate zones with names (and other data as well), and reuse the map and the DB to display data, in my example reading a simple. I was searching for a way to highlight zones (regions, provinces, counties, etc) on a map, and I don't need super precise maps so I wrote this script, based on picking up black and white maps (2 colors BW. With #AutoIt3Wrapper_UseX64=Y it just works, both normal Autoit and beta! Why doesn't it work in 32bit, despite me having the 32bit sqlite.dll? Autoit urges running scripts in 32bit mode and Scite starts scripts just in 32bit mode without the flag? I extended the output of " & & " & $sDll_Filename & & _SQLite_LibVersion() & using the script from for testing. I put sqlite3.dll and sqlite3_圆4.dll in C:\Windows\System32 since many scripts depend on them. I'm afraid I'm not been clear, even if I did my best to be, anyway. 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. The SQL query should 'ask' who is working on a specific day (even for days in the middle of the ranges).
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?
Well, in the case of ranges of days (for example Mr.
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. I have to store information of this kind:Ī person is assigned to a job for a certain day (one day only)Ī person is assigned to a job from a day to another day (a range of days) 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 ask for generic advice on what field format is best to use to store dates in a database (SQLite).
0 kommentar(er)
