Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
Memory table - fields not showing |
Sun, Aug 2 2020 7:07 AM | Permanent Link |
Huseyin Aliz myBiss ApS | 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 |
Sun, Aug 2 2020 8:01 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Sun, Aug 2 2020 9:29 AM | Permanent Link |
Huseyin Aliz myBiss ApS | 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 > |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |