Method MakeCommand

storage/connect/tabext.cpp:569–673

/ MakeCommand: make the Update or Delete statement to send to the */ MySQL server. Limited to remote values and filtering. */ /

/*  MySQL server. Limited to remote values and filtering.              */
/***********************************************************************/
bool TDBEXT::MakeCommand(PGLOBAL g)
{
	PCSZ  schmp = NULL;
	char *p, *stmt, name[132], *body = NULL;
	char *qrystr = (char*)PlugSubAlloc(g, NULL, strlen(Qrystr) + 1);
	bool  qtd = Quoted > 0;
	char  q = qtd ? *Quote : ' ';
	int   i = 0, k = 0;
	size_t stmt_sz = 0;

	// Make a lower case copy of the originale query and change
	// back ticks to the data source identifier quoting character
	do {
		qrystr[i] = (Qrystr[i] == '`') ? q : tolower(Qrystr[i]);
	} while (Qrystr[i++]);

	if (To_CondFil && (p = strstr(qrystr, " where "))) {
		p[7] = 0;           // Remove where clause
		Qrystr[(p - qrystr) + 7] = 0;
		body = To_CondFil->Body;
		stmt_sz = strlen(qrystr) + strlen(body) + 64;
	} else
		stmt_sz = strlen(Qrystr) + 64;
	stmt = (char*)PlugSubAlloc(g, NULL, stmt_sz);

	// Check whether the table name is equal to a keyword
	// If so, it must be quoted in the original query
	snprintf(name, sizeof(name), " %s ", Name);
	strlwr(name);

	if (strstr(" update delete low_priority ignore quick from ", name)) {
		if (Quote) {
			snprintf(name, sizeof(name), "%s%s%s", Quote, Name, Quote);
			strlwr(name);
			k += 2;
		} else {
			safe_strcpy(g->Message, sizeof(g->Message), "Quoted must be specified");
			return true;
		}	// endif Quote

	} else {
		safe_strcpy(name, sizeof(name), Name);     // Not a keyword
		strlwr(name);
	}

	if ((p = strstr(qrystr, name))) {
		for (i = 0; i < p - qrystr; i++)
			stmt[i] = (Qrystr[i] == '`') ? q : Qrystr[i];

		stmt[i] = 0;

		k += i + (int)strlen(Name);

		if (Schema && *Schema)
			schmp = Schema;

		if (qtd && *(p - 1) == ' ') {
			if (schmp) {