if ((NOT IsArray(a1)) OR (NOT IsArray(a2))) {
writeoutput("Error in ArrayConcat()! Correct usage: ArrayConcat(Array1, Array2) -- Concatenates Array2 to the end of Array1");
return 0;
}
for (i=1;i LTE ArrayLen(a2);i=i+1) {
ArrayAppend(a1, Duplicate(a2[i]));
}
SELECT [Datasourcename],
[DBName],
[Driver],
[Buffer]
FROM qRawDatasources
ORDER BY [Driver] ASC, [Datasourcename] ASC
// Set up a look up table for the dbms type.
// The key is the value for the driver returned by the factory and the value is the name used by the scaffolding.
stDBMSLookup["MSSQLServer"] = "mssql";
//stDBMSLookup["mysql4"] = "mysql4";
//stDBMSLookup["mysql"] = "mysql";
//stDBMSLookup["db2"] = "db2";
//stDBMSLookup["oracle"] = "oracle";
//stDBMSLookup["oraclerdb"] = "oraclerdb";
//stDBMSLookup["postgres"] = "postgres";
SELECT Name AS tableName,
Type AS tableType
FROM SYSOBJECTS
WHERE OBJECTPROPERTY(ID, N'IsUserTable') = 1
AND Name != 'dtproperties'
sp_columns '#arguments.tableName#'
sp_pkeys '#arguments.tableName#'
sp_special_columns '#arguments.tableName#'
SELECT qFieldsRaw.Column_Name,
Nullable,
Length,
Type_Name,
Ordinal_Position,
Key_Seq
FROM qFieldsRaw, qPKFields
WHERE qFieldsRaw.Column_Name = qPKFields.Column_Name
UNION
SELECT Column_Name,
Nullable,
Length,
Type_Name,
Ordinal_Position,
0
FROM qFieldsRaw
WHERE 0=0
AND NOT qFieldsRaw.Column_Name = #preservesinglequotes(thisField)#
ORDER BY Ordinal_Position
sp_fkeys @fktable_name = '#arguments.tableName#'
sp_fkeys @pktable_name = '#arguments.tableName#'
[[:space:]]*#chr(13)##chr(9)#[[:space:]]*",">#chr(13)##chr(9)#","all") >
[[:space:]]*#chr(13)##chr(13)##chr(9)#[[:space:]]*",">#chr(13)##chr(9)#","all") >
[[:space:]]*","all") >
[[:space:]]*#chr(13)##chr(9)##chr(9)##chr(9)#[[:space:]]*#chr(13)##chr(9)##chr(9)##chr(9)#
[[:space:]]*#chr(13)##chr(9)##chr(9)##chr(9)#[[:space:]]*#chr(13)##chr(9)##chr(9)##chr(9)#
[[:space:]]*#chr(13)##chr(9)##chr(9)##chr(9)##chr(9)#[[:space:]]*#chr(13)##chr(9)##chr(9)##chr(9)##chr(9)#[[:space:]]*#chr(13)##chr(9)##chr(9)##chr(9)#
SELECT Driver FROM arguments.qDatasources WHERE Datasourcename = '#arguments.stFormData.dsn#'
--->