SQLPrepare

concerns

The SQLPrepare attribute function provides a string with a database-compliant content of the variable.

 

Syntax

SQLPrepare([Prep = OnlyDate])

Return value

Type

Description

String

The value of the variable, SQL-compliant formatted and framed with simple high commas, or NULL at NoValue

Parameter

Use

Name

Type

Passing

Description

Optional

Prep

EnumSQLPrepDate

ByVal

Enum

 

EnumSQLPrepDate

Description

0 – OnlyDate

Only the date is used in the string

1 – DateAndTime

Date and time are used