delphi sql запросы memo

Перейти к контенту

Главное меню:

Интересное
delphi sql запросы memo, Создание SQL-запросов в Delphi - infourok.ru, Using Structured Query Language in Delphi - ThoughtCo, delphi&databases, inserting a memo field with sql - HELP, SQL Query Data in to a Memo - delphi, SQL-запросы в Delphi, SQL-запросы в Delphi - codenet.ru, .
Quote:>    I've been working with Delphi for a while, and now I've run >into a problem that I can find solution for... >    I've created a paradox table through a ttable component (with >t.createtable). However, updating this table with SQL seems to be impossible >when having memo (I guess it's the same for the blob fields). If I send th >query like: >    INSERT INTO mytable VALUES (5,'Tsting','Here is my txt') >    (supposing the first field is an integer, second char[..], and the >last one is memofield), >    the first two fields are updated, but when reading the data, the >memofield is blank... >    I've tried using parameters, but it's also helpless. >    Please, help if you knoww a solution to this problem, and I doubt >that you can't update memo fields with SQL... >    I don't think it's of any kind of help, but let's say that I'm >working on "professional" edition of Delphi... If you have an edition of Delphi named "Professional", then you must be using at least version 3 of Delphi. Updating memo and BLOB columns in SQL was not possible prior to that. What you might want to try doing is using a parameter to represent the memo column in your SQL statement. For example:   INSERT INTO mytable   VALUES (5, 'Tsting', :MemoParm) Note that the above assumes that the third column in the physical table structure is a memo column. Then, just prior to executing the TQuery, assign a value to this parameter.   with Query1 do begin     Close;     ParamByName('MemoParam').DataType := ftMemo;     ParamByName('MemoParam').AsMemo := 'Here is my txt';     ExecSQL;   end; If this does not work for you, then you will need to post the specific version of Delphi and of the BDE that you are using. ////////////////////////////////////////////////////////////////////////// Steve Koterski                      "The knowledge of the world is only to Technical Publications              be acquired in the world, and not in a INPRISE Corporation                 closet." http://www.inprise.com/delphi          -- Earl of Chesterfield (1694-1773) , Это свойство устанавливается в последнюю очередь, в противном случае, возможно возникновение ошибки «ADOQuery1: Missing SQL property», если свойство ADOQuery1.SQL пусто (рисунок 5)., SQL (Structured Query Language) is a standardized language for defining and manipulating data in a relational database. In accordance with the relational model of data, the database is perceived as a set of tables, relationships are represented by values in tables, and data is retrieved by specifying a result table that can be derived from one or more base tables. Queries take the form of a .
If you have an edition of Delphi named "Professional", then you must be using at least version 3 of Delphi. Updating memo and BLOB columns in SQL, I'm looking for some help, I'm trying to get the data that I fetch from my SQL Query in to a Memo. Thanks . Stan, В Delphi, для создания SQL-запроса на лету можно использовать динамические запросы. Динамические запросы допускают использование параметров. Для определения параметра в запросе используется двоеточие (:), за которым , В Delphi, для создания SQL-запроса на лету можно использовать динамические запросы. Динамические запросы допускают использование параметров. Для определения параметра в запросе используется двоеточие (:), за которым , , .
 
Copyright 2019. All rights reserved.
Назад к содержимому | Назад к главному меню