Weird errors V4MD Server/Client

[Florian Bogeschdorfer]

Hi Ruslan, look at this

x=VALselectReturnCursor("SELECT * FROM KUNDENtable WHERE vorname=Florian")
put x
-- <Xtra child "VCursor" 2 4733a24>
put valcursorreccount(x)
-- 44
put x.getRecordAsPropList()
-- [#mobilnummer: "", #mobilnummer_ai: 0, #inhouse: 0, #allowed: 0,
#newDate: "00.00.0000", #lastDate: "00.00.0000", #lastInhouse: "00.00.0000",
#lastActive: "00.00.0000", #flirtID: "", #smsFlirtIDglobal: "", #anrede: "",
#vorname: "", #vorname_ai: 0, #name: "", #name_ai: 0, #zusatz: "",
#strasse1: "", #strasse1_ai: 0, #strasse2: "", #plz: "", #plz_ai: 0, #ort:
"", #ort_ai: 0, #land: "", #geburtsdatum: "00.00.0000", #KD_PICpath: "",
#mixnick: "", #code: "", #Email: "", #telefon: "", #mobilnetz: "",
#telefonSMStauglich: 0, #fax: "", #geschlecht: 0, #spNr: "", #bdNr: "",
#zusatz1: "", #zusatz2: "", #zusatz3: "", #zusatz4: "", #zusatz5: "",
#zusatz6: "", #zusatz7: "", #mailPreferred: "", #KDstatModul1: 0,
#KDstatModul2: 0, #KDstatModul3: 0, #KDstatModul4: 0, #KDstatModul5: 0,
#KDstatModul6: 0, #KD_ID: 0, #KD_BUDlistID: 0, #KD_KDG_ID1: "", #KD_KDG_ID2:
"", #KD_KDG_ID3: "", #KD_KDG_ID4: "", #KD_mailFlag: 0, #KD_smsFlag: 0,
#KD_briefFlag: 0, #KD_faxFlag: 0, #KD_notiz: "", #KD_BLZ: "", #KD_KTO: "",
#KD_BankName: "", #KD_Einzugsermaechtigung: 0, #KD_KTOinhaber: "",
#KD_CC_Inhaber: "", #KD_CC_Nummer: "", #KD_CC_Valid_From: "",
#KD_CC_Valid_To: "", #KD_CC_CardCompany: "", #KD_Ausweisnummer: "",
#KD_mobileApproved: 0, #KD_checkedInToday: 0, #KD_spare1: "", #KD_spare2:
"", #KD_spare3: "", #KD_spare4: 0, #KD_GEB_Year: 0, #KD_GEB_Count: 0]

-- SO FAR SO GOOD. NOW I WANT THE RECORD AS A STRING

put x.getRecordAsString()
-- <Void>

put x.getRecordsAsString()
-- <Void>

put getRecordsAsString(x)
error 5
-- <Void>


-- I DO NOT UNDERSTAND WHY THIS DOES NOT WORK, THE CURSOR IS STILL OK - SEE
BELOW:

put getRecordAsPropList(x)
-- [#mobilnummer: "", #mobilnummer_ai: 0, #inhouse: 0, #allowed: 0,
#newDate: "00.00.0000", #lastDate: "00.00.0000", #lastInhouse: "00.00.0000",
#lastActive: "00.00.0000", #flirtID: "", #smsFlirtIDglobal: "", #anrede: "",
#vorname: "", #vorname_ai: 0, #name: "", #name_ai: 0, #zusatz: "",
#strasse1: "", #strasse1_ai: 0, #strasse2: "", #plz: "", #plz_ai: 0, #ort:
"", #ort_ai: 0, #land: "", #geburtsdatum: "00.00.0000", #KD_PICpath: "",
#mixnick: "", #code: "", #Email: "", #telefon: "", #mobilnetz: "",
#telefonSMStauglich: 0, #fax: "", #geschlecht: 0, #spNr: "", #bdNr: "",
#zusatz1: "", #zusatz2: "", #zusatz3: "", #zusatz4: "", #zusatz5: "",
#zusatz6: "", #zusatz7: "", #mailPreferred: "", #KDstatModul1: 0,
#KDstatModul2: 0, #KDstatModul3: 0, #KDstatModul4: 0, #KDstatModul5: 0,
#KDstatModul6: 0, #KD_ID: 0, #KD_BUDlistID: 0, #KD_KDG_ID1: "", #KD_KDG_ID2:
"", #KD_KDG_ID3: "", #KD_KDG_ID4: "", #KD_mailFlag: 0, #KD_smsFlag: 0,
#KD_briefFlag: 0, #KD_faxFlag: 0, #KD_notiz: "", #KD_BLZ: "", #KD_KTO: "",
#KD_BankName: "", #KD_Einzugsermaechtigung: 0, #KD_KTOinhaber: "",
#KD_CC_Inhaber: "", #KD_CC_Nummer: "", #KD_CC_Valid_From: "",
#KD_CC_Valid_To: "", #KD_CC_CardCompany: "", #KD_Ausweisnummer: "",
#KD_mobileApproved: 0, #KD_checkedInToday: 0, #KD_spare1: "", #KD_spare2:
"", #KD_spare3: "", #KD_spare4: 0, #KD_GEB_Year: 0, #KD_GEB_Count: 0]


????
Still: how can the cursor data be empty, at least the #vorname should be
"Florian"

I have to add that playing with the getRecordAsString() I got errors 5,
189220 and some other strange errors up to 10038:


 10:30:34.621000 (544): (400) SQL: SELECT * FROM KUNDENtable WHERE
vorname=Florian; # of records: 44
 10:30:34.621000 (544): (400) CURSOR(0xF05130): FirstRecord : OK
 10:31:38.963000 (536): (400) CURSOR(0xF05130): NextRecord (2) : OK
 10:33:25.687000 (548): (400) CURSOR(0xF05130): GoToRecord #1 : OK
 10:34:31.962000 (544): (400) CURSOR(0xF05130): GoToRecord #1 : OK
 10:34:34.055000 (536): Client has been suddenly disconnected (400)
 10:34:34.055000 (536): Closing connection (400)

Now I tried after restart:

x=VALselectReturnCursor("SELECT * FROM KUNDENtable WHERE vorname='Florian'")
put x
-- <Xtra child "VCursor" 2 4723d14>
put VALcursorRecCount(x)
-- 44
put getRecordAsPropList(x)
-- [#mobilnummer: "01732426070", #mobilnummer_ai: 560, #inhouse: 0,
#allowed: 0, #newDate: "24.01.2003", #lastDate: "12.11.2003", #lastInhouse:
"00.00.2000", #lastActive: "00.00.0000", #flirtID: "", #smsFlirtIDglobal:
"", #anrede: "Herr", #vorname: "Florian", #vorname_ai: 523, #name: "Mott",
#name_ai: 324, #zusatz: "", #strasse1: "Reinickendorfer Str. 45",
#strasse1_ai: 1578, #strasse2: "", #plz: "13347", #plz_ai: 258, #ort:
"Berlin", #ort_ai: 444, #land: "", #geburtsdatum: "15.10.1978", #KD_PICpath:
"", #mixnick: "", #code: "", #Email: "", #telefon: "", #mobilnetz: "",
#telefonSMStauglich: 0, #fax: "", #geschlecht: 1, #spNr: "", #bdNr: "",
#zusatz1: "", #zusatz2: "", #zusatz3: "", #zusatz4: "", #zusatz5: "",
#zusatz6: "", #zusatz7: "", #mailPreferred: "SMS", #KDstatModul1: 0,
#KDstatModul2: 0, #KDstatModul3: 0, #KDstatModul4: 0, #KDstatModul5: 0,
#KDstatModul6: 0, #KD_ID: 74, #KD_BUDlistID: 0, #KD_KDG_ID1: "",
#KD_KDG_ID2: "", #KD_KDG_ID3: "", #KD_KDG_ID4: "", #KD_mailFlag: 1,
#KD_smsFlag: 1, #KD_briefFlag: 1, #KD_faxFlag: 0, #KD_notiz: "", #KD_BLZ:
"", #KD_KTO: "", #KD_BankName: "", #KD_Einzugsermaechtigung: 0,
#KD_KTOinhaber: "", #KD_CC_Inhaber: "", #KD_CC_Nummer: "",
#KD_CC_Valid_From: "", #KD_CC_Valid_To: "", #KD_CC_CardCompany: "",
#KD_Ausweisnummer: "", #KD_mobileApproved: 0, #KD_checkedInToday: 0,
#KD_spare1: "", #KD_spare2: "", #KD_spare3: "", #KD_spare4: 0, #KD_GEB_Year:
0, #KD_GEB_Count: 0]

put getRecordAsString(x)
-- "
"


Why is the string empty or better filled with spaces and TABs? Where is the
data?

What am I doing wrong?

TIA, Florian

Best regards, Florian