Hi All,

Hope you all are doing fine.
I have following SQL to create a memory table:

CREATE TABLE IF NOT EXISTS "memory\markeretlinier" (
   "OrdreSpecID" INTEGER,"Ordrenr" INTEGER,"Varenr" VARCHAR(25),"Pris"
MONEY,"Antal" FLOAT,"Rabat" FLOAT,"Totalbelob" MONEY,
   "Tekst" VARCHAR(512),"Krediteret" BOOLEAN,"KrediteretAntal"
FLOAT,"Leveret" FLOAT,"Rest" FLOAT,"PrisInklMoms" MONEY,
   "Varekontonr" INTEGER,"LeveretTidligere" FLOAT,"Leverings Dato"
DATE,"TekstRedigerbar" BOOLEAN,"SpecielTekst" VARCHAR(80),
   "Momspct" FLOAT,"Oprettet Af" VARCHAR(10),"Oprettet Tid"
TIMESTAMP,"Opdateret Af" VARCHAR(10),"Opdateret Tid" TIMESTAMP,
   "Afgift" MONEY,"Afgifttotal" MONEY,"Afgifttype"
INTEGER,"Omvendtmomspligt" BOOLEAN,"Opgaveid" INTEGER,"Opgaveafsluttet"
BOOLEAN,
   "Opgaveoverforsel" BOOLEAN,"Webordre" BOOLEAN,"Servicenummer"
VARCHAR(15),"HelTal" BOOLEAN,"TotalprisInklmoms" MONEY,
   "Sagsnr" INTEGER,"Tekstlinie" BOOLEAN,"Projektnr"
INTEGER,"Leveringsnavn" VARCHAR(60),"Leveringsadresse" VARCHAR(120),
   "Leveringstelefon" VARCHAR(15),"Leveringsby"
VARCHAR(60),"Leveringsland" VARCHAR(60),"Leveringsomraade" VARCHAR(60),
   "Leveringskontaktperson" VARCHAR(60),"Leveringsemail"
VARCHAR(60),"Leveringspostnr" INTEGER,"SagsnrID" VARCHAR(20),
   "Kundevare" BOOLEAN,"Rabatbelob" MONEY,"Lokationsnr"
INTEGER,"Lagerstyring" BOOLEAN,"Lagernr" INTEGER,"Folgeseddelnr" INTEGER,
   "LagerstatusIkkeOK" BOOLEAN,"Placering" INTEGER,"Dato"
DATE,"AssetID" INTEGER);

I would expect that:

select * from "memory\markeretlinier";

would show me all fields, but it's not the case. Only 17 of 57 fiels are
returned. I am missing something but what?

Latest DBISAM.

Regards,
Huseyin

Hüseyin


Can you try your code in DBSys please. I've just tried here in my old 4.26 version and it works perfectly. Only the first 14 fields were visible in the grid without scrolling, but scrolling showed them all.

Roy Lambert

Hi Roy,

Thanks for your reply. It was actually in DBsys i was trying, but
scrolling showed them all as you wrote.

Regards,
Huseyin

Den 02-08-2020 kl. 14:01 skrev Roy Lambert:
> Hüseyin
>
>
> Can you try your code in DBSys please. I've just tried here in my old 4.26 version and it works perfectly. Only the first 14 fields were visible in the grid without scrolling, but scrolling showed them all.
>
> Roy Lambert
>