Search found 7 matches
- 09.10.2008, 08:01
- Forum: SQLite Administrator
- Topic: Boolean fields: 1/0 vs Y/N
- Replies: 7
- Views: 2518
- 09.10.2008, 07:57
- Forum: SQLite Administrator
- Topic: Boolean fields: 1/0 vs Y/N
- Replies: 7
- Views: 2518
- 06.10.2008, 10:07
- Forum: SQLite Administrator
- Topic: Boolean fields: 1/0 vs Y/N
- Replies: 7
- Views: 2518
- 03.09.2008, 13:01
- Forum: SQLite Administrator
- Topic: Boolean fields: 1/0 vs Y/N
- Replies: 7
- Views: 2518
Are you sure that both the ways are supported? Somewhere I used one, somewhere the second... Yes I'm quite sure. At the moment I have a table with a boolean field. Half of the entries are from an import that I did from a CSV file. These entries' boolean fields are either 1 or 0. The other entries w...
- 01.09.2008, 16:37
- Forum: SQLite Administrator
- Topic: Boolean fields: 1/0 vs Y/N
- Replies: 7
- Views: 2518
Boolean fields: 1/0 vs Y/N
Hi, When editing table data by using the Edit Data tab, checking / unchecking checkboxes for boolean fields enters Y or N in the fields. I understand that Sqlite is weakly typed and that using Y/N as opposed to 1/0 is a personal choice, but I really feel that 1/0 is a better option. Almost all the o...
- 29.05.2007, 15:22
- Forum: SQLite Administrator
- Topic: Automapping CSV import fields
- Replies: 0
- Views: 1962
Automapping CSV import fields
Hi, This would require some work, but I often have to import a CSV file where the column headers are identical to the destination table's field names. It often is about 30 columns, so I have to go through the tedious process of mapping the source column to the destination column, even though the nam...
- 30.04.2007, 14:06
- Forum: SQLite Administrator
- Topic: Default Sqlite database version
- Replies: 1
- Views: 2041
Default Sqlite database version
When creating a new Sqlite database, I suggest that you make version 3 the default version. Currently version 2 is selected by default.
regards,
igitur
regards,
igitur