I am looking at a query from crystal reports and it shows a table name immediately followed by a table name. see below if that didn’t make sense but I am trying to understand what this syntax is/does? thank you in advance for any insight Answer The 2nd name is the alias. It allows you to refer to the ta…
Tag: pervasive
Does Pervasive Have a SQL Function for URL Encoding?
I’ve written a query that builds some URLs to an intranet site, but some of the URLs don’t work because they contain special characters that need to be URL encoded. I’m trying to avoid writing a script (outside of SQL) to do the URL encoding; I’d like the database to do URL-Encoding in…
F# Query Exception, “unrecognized method call value”
Q: What does the following exception mean? I’m attempting to translate a Pervasive SQL query to an F# query using SqlDataProvider with an ODBC connection, building up slowly bit by bit. I’m getting an exception with the following query with a somewhat cryptic exception. When the printfn statement …
Combining columns into records for WHERE IN()
First, I am sorry. I do not have control to change how the data is stored, so I have to work with it the way it is. I have some tables in a Pervasive database that looks like this: Records: id | …