<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm using sqlite3 on embedded system. > I've got a very very large > memory usage. > > zSql = > sqlite3_mprintf("SELECT PortNumber, RangeMin, RangeMax, Offset, MinL, > MinLL, MaxH, MaxHH, Delay, Hysteresis, " \ > "Alarm, > TimeAlarm FROM input_ai WHERE Address=%d and Monitor='Y';", 7);
sqlite3_mprintf allocates memory on the heap and returns pointer to it. You should deallocate it with sqlite3_free. Better still, use parameterized query - see sqlite3_bind_* Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
