Hey Guys,

We just switched or Warehouse to client/server from direct and now the sql query I have that I run daily does not work through Atrex.

Anything you can tell me?

Here is the sql code

drop table if exists restockbf;
drop table if exists restockca;
drop table if exists restockva;
drop table if exists restockfa;
drop table if exists restockgb;
drop table if exists restockkm;
drop table if exists restockpm;
drop table if exists restockps;
drop table if exists restocksa;
drop table if exists restockwk;
drop table if exists restockwo;

select * into restockbf from "c:\atrex\bayfield\invoice" i
  join "c:\atrex\bayfield\invitem" ii on i.number = ii.number
where i.transdate >= CURRENT_DATE - 14;

select * into restockca from "c:\atrex\cambridge\invoice" i
  join "c:\atrex\cambridge\invitem" ii on i.number = ii.number
where i.transdate >= CURRENT_DATE - 14;

select * into restockva from "c:\atrex\vaughan\invoice" i
  join "c:\atrex\vaughan\invitem" ii on i.number = ii.number
where i.transdate >= CURRENT_DATE - 14;

select * into restockfa from "c:\atrex\fanshawe\invoice" i
  join "c:\atrex\fanshawe\invitem" ii on i.number = ii.number
where i.transdate >= CURRENT_DATE - 14;

select * into restockgb from "c:\atrex\grand bend\invoice" i
  join "c:\atrex\grand bend\invitem" ii on i.number = ii.number
where i.transdate >= CURRENT_DATE - 14;

select * into restockkm from "c:\atrex\kazmania\invoice" i
  join "c:\atrex\kazmania\invitem" ii on i.number = ii.number
where i.transdate >= CURRENT_DATE - 14;

select * into restockmp from "c:\atrex\portkazmania\invoice" i
  join "c:\atrex\portkazmania\invitem" ii on i.number = ii.number
where i.transdate >= CURRENT_DATE - 14;

select * into restockps from "c:\atrex\port stanley\invoice" i
  join "c:\atrex\port stanley\invitem" ii on i.number = ii.number
where i.transdate >= CURRENT_DATE - 14;

select * into restocksa from "c:\atrex\sarnia\invoice" i
  join "c:\atrex\sarnia\invitem" ii on i.number = ii.number
where i.transdate >= CURRENT_DATE - 14;

select * into restockwk from "c:\atrex\walkerrd\invoice" i
  join "c:\atrex\walkerrd\invitem" ii on i.number = ii.number
where i.transdate >= CURRENT_DATE - 14;

select * into restockwo from "c:\atrex\white oaks\invoice" i
  join "c:\atrex\white oaks\invitem" ii on i.number = ii.number
where i.transdate >= CURRENT_DATE - 14;

drop table if exists bayfieldcode;
drop table if exists cambridgecode;
drop table if exists vaughancode;
drop table if exists fanshawecode;
drop table if exists grandbendcode;
drop table if exists kazmaniacode;
drop table if exists portstanleycode;
drop table if exists maniaportcode;
drop table if exists sarniacode;
drop table if exists walkerrdcode;
drop table if exists whiteoakscode;

select * into BAYFIELDCODE from "c:\atrex\bayfield\code";

select * into CAMBRIDGECODE from "c:\atrex\cambridge\code";

select * into VAUGHANCODE from "c:\atrex\VAUGHAN\code";

select * into FANSHAWECODE from "c:\atrex\fanshawe\code";

select * into GRANDBENDCODE from "c:\atrex\grand bend\code";

select * into KAZMANIACODE from "c:\atrex\kazmania\code";

select * into PORTSTANLEYCODE from "c:\atrex\port stanley\code";

select * into MANIAPORTCODE from "c:\atrex\portkazmania\code";

select * into SARNIACODE from "c:\atrex\sarnia\code";

select * into WALKERRDCODE from "c:\atrex\walkerrd\code";

select * into WHITEOAKSCODE from "c:\atrex\white oaks\code";