2. PHPRunner General questions
  3. Primary Key Does not Display on Look up Wizard : Error
This topic is locked

Primary Key Does not Display on Look up Wizard : Error

 		7/7/2009 12:11:47 AM
PHPRunner General questions
S
 sweethard010 author

hi... I try to test the Phprunner Ver 5.1 build 2340. im using MSaccess as my Database just for testing different database.

It works fine in my mySQL.

Problem found in Ms Access only...
In my LOOKUPWIZARDusing table, i set my primary key as linked field then i still want it to display on the display field, but if im going to select more than 2 fields including my Primary key to display, it causes an ERROR: That says : Failed to get list of values from the database.

AND if i will not include the Primary key in the Display Field, the Look Up table runs perfectly..BUT not all the time...bcoz some selected fields does not display also..
This is my Actual Code :

Counter + ') SIZE: ' + Meter_Size_Num + ' Meter Initial ' + Meter_Initial
if i will not include Counter field then this run Perfectly. Why ?
J
 		Jane 7/7/2009

Hi,
this error happens because you try to join numeric and text field. Try to use this code:

CStr(Counter) + ') SIZE: ' + Meter_Size_Num + ' Meter Initial ' + Meter_Initial
S
 		sweethard010 author 7/7/2009

Hi,

this error happens because you try to join numeric and text field. Try to use this code:


thanx jane.. your right... actually i already read that answer in some threads in this forum before i post my problem..>> my Field Name is Misspelled. because of this:

If i try to copy text scripts from EVENT to another EVENT or any field in the same project, the last CHARACTER of the copied text is NOT included when I paste it. Why is that.?

I try different PC but still do the same thing.. Please help..

EXAMPLE:

i copy : HELP then if i paste it this will be the pasted text : HEL
J
 		Jane 7/8/2009

Hi,
thank you for pointing me to this bug.

We'll fix it in the next update.