Page 3 of 3

Re: CSV.BAT - CSV file manipulation with SQL syntax

Posted: 27 Nov 2018 13:42
by npocmaka_
Ed Dyreen wrote:
24 Nov 2018 12:22
why don't you use SQL scripts to create, manage, convert update or delete databases ?

Can your SQL program not do that ?
Because I had CSVs. This script is not bad for basic CSV processing and the JET Engine is a basically a database engine installed with your windows by default. Though It can be extended - It would be useful if you can use/create a custom schema file in order to handle other data types than string.

Re: CSV.BAT - CSV file manipulation with SQL syntax

Posted: 27 Nov 2018 14:10
by Squashman
npocmaka_ wrote:
27 Nov 2018 13:42
It would be useful if you can use/create a custom schema file in order to handle other data types than string.
I thought Rojo explained how to do that in this thread because I had asked him about it.

Re: CSV.BAT - CSV file manipulation with SQL syntax

Posted: 28 Nov 2018 12:59
by rojo
Squashman wrote:
27 Nov 2018 14:10
npocmaka_ wrote:
27 Nov 2018 13:42
It would be useful if you can use/create a custom schema file in order to handle other data types than string.
I thought Rojo explained how to do that in this thread because I had asked him about it.
I think he did. viewtopic.php?p=43562#p43562

Re: CSV.BAT - CSV file manipulation with SQL syntax

Posted: 28 Nov 2018 13:31
by npocmaka_
rojo wrote:
28 Nov 2018 12:59
Squashman wrote:
27 Nov 2018 14:10
npocmaka_ wrote:
27 Nov 2018 13:42
It would be useful if you can use/create a custom schema file in order to handle other data types than string.
I thought Rojo explained how to do that in this thread because I had asked him about it.
I think he did. viewtopic.php?p=43562#p43562
Thanks.