Suggested Articles
Search found 8 matches
- Thu Aug 20, 2009 6:05 am
- Forum: Common Problems
- Topic: SQL Problems with 7.1.3
- Replies: 9
- Views: 7593
- Jump to post
Re: SQL Problems with 7.1.3
We have a scheduled task at each site that routinely reports on the version status of database objects and emails it to the helpdesk. By running some custom SQL that checks the source code in SQL Server. We take the bits on information that we need from the comments in the code. Output example ...
- Wed Aug 19, 2009 12:49 am
- Forum: Common Problems
- Topic: SQL Problems with 7.1.3
- Replies: 9
- Views: 7593
- Jump to post
Re: SQL Problems with 7.1.3
Yes this fixes the problem, but we actually want the comments in the installed version of the script. If nothing else we have a header block in the scripts that lists its version history.
Please note that the comments are only stripped when the SQL is submitted to the server. The .sql file itself ...
Please note that the comments are only stripped when the SQL is submitted to the server. The .sql file itself ...
- Tue Aug 18, 2009 12:48 am
- Forum: Common Problems
- Topic: SQL Problems with 7.1.3
- Replies: 9
- Views: 7593
- Jump to post
Re: SQL Problems with 7.1.3
In order to avoid errors caused by comments, it is recommended that you use the "Strip comments from SQL Script" checkbox so that all comments are stripped before sending the query to the server.
Yes this fixes the problem, but we actually want the comments in the installed version of the script ...
Yes this fixes the problem, but we actually want the comments in the installed version of the script ...
- Mon Aug 17, 2009 12:48 am
- Forum: Common Problems
- Topic: SQL Problems with 7.1.3
- Replies: 9
- Views: 7593
- Jump to post
Re: SQL Problems with 7.1.3
Gabriel,
I've figured out the problem (thanks to the logging link).
Some of our scripts have comments after the last go in the script. These comments are normally examples on how to use / call the script. In the older version of your software this did not cause a problem but in the 7.1.x version ...
I've figured out the problem (thanks to the logging link).
Some of our scripts have comments after the last go in the script. These comments are normally examples on how to use / call the script. In the older version of your software this did not cause a problem but in the 7.1.x version ...
- Fri Aug 14, 2009 8:36 am
- Forum: Common Problems
- Topic: SQL Problems with 7.1.3
- Replies: 9
- Views: 7593
- Jump to post
SQL Problems with 7.1.3
We are in the process of upgrading an existing installer for one of our applications.
The SQL scripts that are run have not been upgraded but the programs files have.
The MSI when built with 7.1.3 fails during the "Executing install SQL scripts" with "SQL script parse error: invalid syntax."
When ...
The SQL scripts that are run have not been upgraded but the programs files have.
The MSI when built with 7.1.3 fails during the "Executing install SQL scripts" with "SQL script parse error: invalid syntax."
When ...
- Thu Jul 02, 2009 1:25 am
- Forum: Common Problems
- Topic: SQL Scripts - Don't run on Repair/Modify
- Replies: 3
- Views: 2799
- Jump to post
Re: SQL Scripts - Don't run on Repair/Modify
Cosmin,
I figured this out by comparing the existing aip and a new project. It seems that the Advanced Installer program does not upgrade the AIP project file correctly. Our existing aip has the following header.
<DOCUMENT type="Advanced Installer" CreateVersion="6.1.1" version="7.0.1" modules ...
I figured this out by comparing the existing aip and a new project. It seems that the Advanced Installer program does not upgrade the AIP project file correctly. Our existing aip has the following header.
<DOCUMENT type="Advanced Installer" CreateVersion="6.1.1" version="7.0.1" modules ...
- Wed Jul 01, 2009 6:17 am
- Forum: Common Problems
- Topic: SQL Scripts - Don't run on Repair/Modify
- Replies: 3
- Views: 2799
- Jump to post
SQL Scripts - Don't run on Repair/Modify
We are shipping an update to our product. The last installer was done in 6.3 and this time we are using the latest version 7.0.1.
Somewhere along the line a new checkbox got added to the SQL Script page. Run SQL Script during maintenance (Repair/Modify). Since I want our scripts to run during a ...
Somewhere along the line a new checkbox got added to the SQL Script page. Run SQL Script during maintenance (Repair/Modify). Since I want our scripts to run during a ...
- Wed Mar 12, 2008 6:58 am
- Forum: Feature Requests
- Topic: SQL Scripts
- Replies: 1
- Views: 3450
- Jump to post
SQL Scripts
We are looking at purchasing your installer product. However there are some features that would be nice, mainly better management of SQL scripts.
Our system on install will run the scripts into 2 databases (live and training). The problem is that you have to add them 1 by 1 in the GUI. If I'm doing ...
Our system on install will run the scripts into 2 databases (live and training). The problem is that you have to add them 1 by 1 in the GUI. If I'm doing ...