SQL database queries

How to get the best out of your database.
Post Reply
Posts: 2
Joined: Wed Jun 12, 2024 10:14 am
Company: GL irrigação
City / Town: Itueta, MG, Brasil
Product: Irricad Standalone

SQL database queries

Post by Guilhermeantonio94 »

I'm taking my first steps with Irricad.
I would like to know more about the databases, so I can configure them so that I can make updates to the prices of goods quickly and efficiently.
How should I proceed?
User avatar
Site Admin
Posts: 865
Joined: Thu Mar 12, 2009 2:57 pm
Company: Lincoln Agritech Ltd, IRRICAD Software
City / Town: Lincoln
Location: Canterbury, New Zealand

Re: SQL database queries

Post by jovivier »

Hi Guilhermeantoinio,

The database editor manual is a good place to start learning about how the database editor works. Unfortunately we do not teach SQL but are happy to write specific queries upon request for current version users. There are also quite a few forum posts about the database editor and SQL queries including viewtopic.php?p=1934#p1934, which shows a working example of bringing updated pricing information from an Excel spreadsheet into your database.

If you wish to know specifics please contact your local priority support team or post another question.

Post Reply