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?
SQL database queries
-
- Posts: 2
- Joined: Wed Jun 12, 2024 10:14 am
- Company: GL irrigação
- City / Town: Itueta, MG, Brasil
- Product: Irricad Standalone
- jovivier
- Site Admin
- Posts: 900
- Joined: Thu Mar 12, 2009 2:57 pm
- Company: Lincoln Agritech Ltd, IRRICAD Software
- City / Town: Lincoln
- Location: Canterbury, New Zealand
- Contact:
Re: SQL database queries
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.
The IRRICAD Team
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.
The IRRICAD Team