Código Delphi
[-]unit frmModelo;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, DBTables, StdCtrls, Buttons, Grids, DBGrids, ComCtrls, Mask,
DBCtrls;
type
TfrmModelo1 = class(TForm)
DBGrid1: TDBGrid;
IMPRIMIR: TBitBtn;
SALIR: TBitBtn;
Label1: TLabel;
Label2: TLabel;
Label3: TLabel;
DataSource1: TDataSource;
Query1: TQuery;
DBEdit1: TDBEdit;
DBEdit2: TDBEdit;
DBEdit3: TDBEdit;
Query1NUM_CTA: TStringField;
Query1NUMDEPTO: TSmallintField;
Query1CONCEP_PO: TStringField;
Query1TIPCAMBIO: TFloatField;
Query1MONTOMOV: TFloatField;
procedure FormShow(Sender: TObject);
private
public
end;
var
frmModelo1: TfrmModelo1;
Tab: String;
implementation
{$R *.dfm}
procedure TfrmModelo1.FormShow(Sender: TObject);
begin
Tab:= 'MO' + FormatDateTime('mmyy', Now) + '01';
query1.sql.text:= 'SELECT NUM_CTA,NUMDEPTO,CONCEP_PO,TIPCAMBIO, CASE WHEM DEBE_HABER='+QUOTEDSTR('D')+' THEN SELECT MONTOMOV as DEBE FROM '+Tab+' END, CASE WHEM DEBE_HABER='+QUOTEDSTR('H')+' THEN SELECT MONTOMOV as HABER FROM '+Tab+' END from '+Tab+'';
Query1.Active:=True;
end;
end.
y el errorn que me da cuando intenta entrar en la informacion de la tablame dice token: when