TOPIC: Still unable to get new value.
#1008
Still unable to get new value. 2 Years, 11 Months ago
Thanks Andrew,

But it is still troubling me,i think i am doing something
wrong somewhere.
I Created a new table with one column without key and
then i write rule as per your guidance for my invoice field
but it gives error :

query: select: nonexistent columns:
(getnextnum_reserved_till)

Please Help.
 
 
#1009
Re:Still unable to get new value. 2 Years, 11 Months ago
Sounds like you are using GetNextNum instead of GetNextNumber

GetNextNum is a new version that still has issues. It has different requirements.
 
 
andrew
 
#1010
Re:Still unable to get new value. 2 Years, 11 Months ago
You are right Andrew,I didnt knew diff between both and i typed GetNextNum
instad of GetNextNumber in my coding.

After correcting it i am getting message "

"GetNextNumber failed,no records in : pecount
(pecount-single record table)

I think it is because null value field.plase guide me.

Further i dont know how to store new value in my pecount table.help me.

Thanks for your valuable support.
 
 
#1011
Re:Still unable to get new value. 2 Years, 11 Months ago
Sorry, I forgot to mention that you need to initialize the table with an initial value. You can do this a variety of ways, one is to use IDE > Access a Query, choose your table (pecount), and then create a record. Or you could use QueryView and run something like:

insert { myfield: 1 } into pecount
 
 
andrew