привет всем !!!
БД BDE(FoxPro,dbf),с начала я создаю таблицу Tmp,('CREATE TABLE TMP....)
и туда заливаю данные,т.е хочу залить так:
INSERT INTO TMP(data,nmbpzd,indpzd,vg,wght)
select distinct data,nmbpzd,indpzd,vg,wght
from vag0805
Where substring(indpzd from 1 for 4)="6656" and substring(indpzd from 8 for 4)="6669" and kop="01" and stop="66560" and nmbpzd BETWEEN "3451"
and "3488" and (stnzn BETWEEN "2542" and "2596" or stnzn BETWEEN "2675" and "2685" or stnzn BETWEEN "2700" and "2781"
or stnzn BETWEEN "6475" and "6572" or stnzn BETWEEN "6600" and "6639" or stnzn ="6665" or stnzn BETWEEN "6669" and "9981")пишет:
Type mismatch in expression.
может я чё то пропустил????