SmarteSoft Forum

Default settings and description for the SmarteScript.ini configuration file. You will need to login to download the spreadsheet.

 

1.Printing column headers
a) It is not possible to pass -h or any other switches because SmarteScript executes SQL statements and not SQLCMD commands.
b) RunSQL command executes one SQL statement at a time, so its output contains results from just one query. It is not possible to return column headers and table data in one SQL query.

Suggested workaround:
Step 1
Output column names into a file with query like SELECT COLUMN_NAME FROM [DATABASE].INFORMATION_SCHEMA.Columns where TABLE_NAME = 'table_name'
Step 2
Output table data into another file query like SELECT * FROM [DATABASE].dbo.[table_name]
Step 3
Merge two files together with File commands. This will require some programming.

2. NULL values
SmarteScript just ignores NULL values and does not put them into output. At this time there are no workarounds. At this time, this is how it is implemented - SmarteScript intentionally skips NULL values. Our team agrees and believes this should not behave this way. This will be examined and has been added to our enhancement list, which should be implemented in the near future.
3. Crash in incorrect SQL statements
We have failed to reproduce this issue. Could you please send in (support@smartesoft.com) your test script folder that contains the reproducible issue? Also, the SmarteScript version you are currently using.

I was using the RunSQL command in a script to output to a file and got the data as requested but without the column headers I was hoping for in the results.  I know when running SQLCMD from the command line I can pass the parameter of -h to force the headers in the result but trying to do that within my RunSQL Command actually caused the application to crash.

Is there a way to get the headers returned in the output file with the RunSQL command or another way to get that information?

Another issue I have is that some columns in my query have null values and when placed in the output file the column is skipped so it has 1 less column for every null value in the results. 

Both of these issues This makes it hard to utilize the RunSQL command and output file since I cannot depend on querying a column header or appropriate positional reference.

Can a positional place holder comma set be forced for NULL values?


Finally I found a couple ways to crash the application when badly formatted SQL or a value not expected  is provided to the RunSQL SQL Statement parameter.

For example I inadvertently crashed it via the following methods:

1. Having a table alias defined then forgetting to put the alias prefix before the period when referencing it in a join; e.g. "select a.id from temp a join temp2 b where .id = a.id"

2. When I tried to prefix the query with a -h + followed by the quoted SQL Statement, eg. -h + "select a.id from temp"

SmarteTime is the external tool to automate test scheduling. The user can access any test script and execute them through out the network at any time.

We will have someone contact you with more information.

This should have been resolved already. please confirm.

We were able to reproduce this and have logged it in. This issue should be fixed in the next version release.

For 64-bit machines, please use the following textract.ini file

I thought this was discussed once, but had no luck finding it if it was...

I just triple-checked this and I have at least one script which, every time I load it, then immediately close it prompts with 'Do you want to save test : "__________" ?'

I'm really just wanting to look it over, not change it, and didn't make any change directly.  There must be some rules which either change it without my being aware, or the message is being displayed erroneously.

Does anyone know what's going on?

Thanks a bunch-

I would like to know how to use an external command to have SmarteScript auto-launch and execute a particular script through either my job scheduler or build script?  As well I would like to know if there is a way to pass a datafile, scenario loop file, or specific scenario to run within a script?  I know how to call a script within a script but not how to start SmarteScript and luanch a particular script.

Basicaly I am seeking a way to use the same script (e.g. Login) across different computers with different data files to avoid contention as part of an auto-build QA automated smoke test suite.

To access the the 3rd column of the array, the user will need to create a three dimension array.

Defining the array in the Scripts header code:

array(str,str,str)ArrayName;