Forum Discussion

Qrew Cadet

3 years ago

Formula Query Error - The way this formula is built will take too long to process.

Is URLEncode() not functional inside of a Formula Query? When I attempt to use it, I receive this error message. Here is my formula: Size(GetRecords("{52.EX." & URLEncode([Job]) & "}AND{27...

formula queries

MikeTamoush

Qrew Commander

I get that error a lot when I'm trying to find duplicate values in a large table (30,000+ records).

Are you querying a large table?

------------------------------
Mike Tamoush
------------------------------

JonFroderberg

Qrew Cadet

3 years ago

Hi Mike-
Yes, this is a fairly busy table. 80K+ records and 244 fields.

------------------------------
Jon Froderberg
PRIME Developer
Harder Mechanical Contractors
https://www.harder.com
Portland, OR
801.946.0576
------------------------------

MikeTamoush
Qrew Commander
3 years ago
I'd be willing to be it is the size of the table. I have not found a work around or a way to get it to query my tables that big. Please post back if you come up with a solution!

------------------------------
Mike Tamoush
------------------------------