Database Error WHERE Clause

[Gintaras]

Must be CSV, ie comma-separated. If it is tab-separated, let file extension be tab.

Note: this macro replaces text in file "C:\Temp\move.tab".

Macro Macro3129

Code:

Copy      Help

out
;tab-separated columns
str s =
;Date    Rep    Total
;7/19/2022 7:48:34 AM    10    600
;7/19/2022 8:18:56 AM    10    600
;7/19/2022 8:39:38 AM    20    600
s.setfile("C:\Temp\move.tab")

Database dbt.Open(dbt.CsText("C:\Temp"))
ARRAY(str) at
dbt.QueryArr("SELECT * FROM move.txt WHERE rep=10" at)
int i
for i 0 at.len
,out F"Date={at[0 i]}, Rep={at[1 i]}, Total={at[2 i]}"