DBLOOKUP questions...

[new2game]

When I code a select statement to grab a sequence number using DBQUERY the responses contain 'value + !'. Using DBLOOKUP the response is 'value'.

Why does QUERY bring back the terminator?

Can anyone tell me what the difference is and when I'd want to use QUERY verses LOOKUP?

When I use an indexing formula here a 2.5mb input is mapped in 1 second or less. Using the DBLOOKUP it takes 13 seconds. Production files will be substantialy bigger so time is issue. The formula is goofy and cumbersome. Is there a solution?

 

[BocaBurger]

1. read the documentation.
2. The database will perform database functions much faster than DSTX. Depending on what you are looking for a stored procedure call might help.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!