I’m Using Advantage Server 12. I need a result set that finds all the records when the supplied parameter occurs in either of a master or a detail table when the supplied value is not the linking field. Customer Table N < 2 Contact Table N >=0 Require the Row from Customer and All rows with matching ACODE from Contacts.
Tag: advantage-database-server
How to insert file upload content to database by sending base64 encoded file content via json?
From my php page I send file upload content as then send this to payload – REST API in python then in my python code I write like this Now I try inserting this to my database using sql where the image column is binary(blob) type but this end in error… Am I doing in right way ? or there
Creating index if index doesn’t exist
I have a problem creating an index with the advantage database server if it doesn’t exist with a sql query. My query looks like this: So I don’t use FullTextSearchIndizes,because it is a integer field. Otherwhise it would look like this: So, my only problem is how do I get the indices. I’ve read in other DBMS you can use