 | |
another setGenFilter question
comp.databases.paradox comp.databases.paradox
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
another setGenFilter question -
02-03-2007
, 08:46 PM
#2
| |||
| |||
|
|
I have a field called hospitalnumber and I want to use setGenFilter. The field looks like this 123-45-67 (with the dashes) When I use code: AR["HospitalNumber"] =stMR ;// stMR is the hospitalnumber TCBio.setGenFilter(AR) I get the error: "The filter expression in field HospitalNumber is not valid "Operation not applicable" Is this because of the dashes? I tried to break it apart and make it look like: 123/-45/-67. But that didn't seem to work. Any work arounds? Thanks Craig Craig Futterman |
#3
| |||
| |||
|
|
Craig, stMR = "\\" + stMR ...should do it. The ObjectPAL help on setGenFilter explains that when your filter criteria starts with a number, you need to put the \\ before it. Liz Craig wrote: I have a field called hospitalnumber and I want to use setGenFilter. The field looks like this 123-45-67 (with the dashes) When I use code: AR["HospitalNumber"] =stMR ;// stMR is the hospitalnumber TCBio.setGenFilter(AR) I get the error: "The filter expression in field HospitalNumber is not valid "Operation not applicable" Is this because of the dashes? I tried to break it apart and make it look like: 123/-45/-67. But that didn't seem to work. Any work arounds? Thanks Craig Craig Futterman |
#4
| |||
| |||
|
|
Another fun Saturday night.... Is thar you call in your hospital : "The Saturday night fever..." |
OT: this afternoon, I'll go to a jewellry fair, and if your wife is
interested on documentation about "french trend", just give me your mail
address, (in private)
I'll be pleased to post her all I get.
Régis
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.