|
아래 질의문(qryStr)에서 NameMaster."Name" 형식으로 하셨는데
그렇게 하시면 안되고 NameMaster.Name 형식으로 하셔야 합니다.
DatabaseName.TableName.FieldName 형식으로 하셔야 합니다.
따옴표가 들어가면 안 된다는 뜻입니다.
: qryStr = qryStr + "select NameMaster.\"ID\" ," +
: "NameMaster.\"Name\"," +
: "NameMaster.\"OfficeName\"," +
: "NameMaster.\"TelOffice\"," +
: "NameMaster.\"HandPhone\" " +
: "from \"NameMaster.db\" NameMaster" +
:
: "where NameMaster.\"Name\" >= \"%" +
: StartName + "%\" " +
: "And NameMaster.\"Name\" < \"%" +
: EndName + "%\" " +
:
: "order by NameMaster.\"Name\" Asc";
:
김용준 님이 쓰신 글 :
:
: Unit1.cpp 내용입니다.
:
:
: //---------------------------------------------------------------------------
:
: #include <vcl.h>
: #pragma hdrstop
:
: #include "Unit1.h"
: #include "Unit2.h" //me..........
:
: //---------------------------------------------------------------------------
: #pragma package(smart_init)
: #pragma resource "*.dfm"
: TForm1 *Form1;
: AnsiString qryStr; //me.............
:
: //---------------------------------------------------------------------------
: __fastcall TForm1::TForm1(TComponent* Owner)
: : TForm(Owner)
: {
: }
: //---------------------------------------------------------------------------
:
: void __fastcall TForm1::QryByBtn(TObject *Sender)
: {
: StartName = StartChar[TPanel(Sender).Tag];
: EndName = StartChar[TPanel(Sender).Tag+1];
: qryStr ="";
: qryStr = qryStr + "select NameMaster.\"ID\" ," +
: "NameMaster.\"Name\"," +
: "NameMaster.\"OfficeName\"," +
: "NameMaster.\"TelOffice\"," +
: "NameMaster.\"HandPhone\" " +
: "from \"NameMaster.db\" NameMaster" +
:
: "where NameMaster.\"Name\" >= \"%" +
: StartName + "%\" " +
: "And NameMaster.\"Name\" < \"%" +
: EndName + "%\" " +
:
: "order by NameMaster.\"Name\" Asc";
:
:
: DataModule2->Query1->Close();
:
: DataModule2->Query1->SQL->Text=qryStr;
: DataModule2->Query1->Open();
: }
:
: //---------------------------------------------------------------------------
:
:
:
: unit1.h 내용입니다.
:
:
: #include <DBGrids.hpp>
: #include <ExtCtrls.hpp>
: #include <Grids.hpp>
: //---------------------------------------------------------------------------
: class TForm1 : public TForm
: {
: __published: // IDE-managed Components
: TPanel *Panel1;
: TPanel *Panel2;
: TPanel *Panel3;
: TPanel *Panel4;
: TPanel *Panel5;
: TDBGrid *DBGrid1;
:
:
: void __fastcall QryByBtn(TObject *Sender); //me............
:
:
: private: // User declarations
: public: // User declarations
:
: AnsiString StartName, EndName; //me...........
:
:
: __fastcall TForm1(TComponent* Owner);
: };
:
: const AnsiString StartChar[] = {
: "j","k","l","m"}; //me...............
:
: //---------------------------------------------------------------------------
: extern PACKAGE TForm1 *Form1;
: //---------------------------------------------------------------------------
: #endif
:
:
: unit2.cpp 내용입니다..
:
: //---------------------------------------------------------------------------
:
: #include <vcl.h>
: #pragma hdrstop
:
: #include "Unit2.h"
:
: #include "Unit1.h" //me........???????
:
:
: //---------------------------------------------------------------------------
: #pragma package(smart_init)
: #pragma resource "*.dfm"
: TDataModule2 *DataModule2;
: //---------------------------------------------------------------------------
: __fastcall TDataModule2::TDataModule2(TComponent* Owner)
: : TDataModule(Owner)
: {
: }
: //---------------------------------------------------------------------------
:
:
: panel 을 누르면 거기에 해당하는 name 의 자료를 보여주려고 하는데요..시험삼아 만들어 보는거라 a 에서 z 까지 다 하지는 않았구요..
: 그래도 돌아가야 할꺼 같은데...
:
: panel 을 누르면 invalid use of keyword
: token:NameMaster."Name"
: 이런 에러가 자꾸 뜨는군요..
: 뭐가 문제죠?
: 하루죙일 고민 중 입니다...
:
:
|