Hola foro mi pregunta es la siguiente:Tengo un array de tipo AnsiString.
AnsiString BD[9] = {"AbueloDal","AbueloSeg","Bisabuelo","Duroc","LargeWhite","Pietrain","AnalisisDetallado","AnalisisExtraccion","DosisMensuales"};
y quiero con un for contruir una sentencia SQL del tipo.
for (cont = 0; cont<=8; cont++){
Query1->SQL->Clear();
DBGrid1->Refresh();
Query1->SQL->Add("Select * from :parametro");
RP = BD[cont];
Query1->Params->Items[0]->AsString = BD[cont];
Query1->Prepare();
Query1->Open();
}
Pero pasa lo siguiente el ODBC me da error por que al parecer la sentencia Select * from :parametro da un error he echo un debuging y pasa los siguiente el vector ansistring vales los valore que he introducido pero añadiendo data.
BD[9] = {Data:"AbueloDal",......}
Entonces supongo que ahí está el error el puto data (perdón por mi vocabulario pero es que me estoy desesperando).
Así que he ahí me pregunta cómo puede acceder al dato que realmente necesito es decir si accedo al primer dato "AbueloDal".
¿Alguna idea?
Por si acaso envío todo el código.
//---------------------------------------------------------------------------
#define NO_WIN32_LEAN_AND_MEAN
#include <dos.h>
#include <stdio.h>
#include <vcl.h>
#include <shlobj.h>
#include <FileCtrl.hpp>
#pragma hdrstop
#include "Unit6.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TForm6 *Form6;
int col,i,cont;
TDataSet *pDS;
struct date d;
//---------------------------------------------------------------------------
__fastcall TForm6::TForm6(TComponent* Owner)
: TForm(Owner)
{
Label1->Caption = DateToStr(Date());
ComboBox1->Text = ComboBox1->Items->Strings[0];
pDS = DBGrid1->DataSource->DataSet;
}
//---------------------------------------------------------------------------
void __fastcall TForm6::Button1Click(TObject *Sender)
{
bool encontrado;
AnsiString BD[9] = {"AbueloDal","AbueloSeg","Bisabuelo","Duroc","LargeWhite","Pietrain","AnalisisDetallado","AnalisisExtraccion","DosisMensuales"};
AnsiString RP = "VACIO";
AnsiString pp0 = "C:\\Sebas\\";
AnsiString pp1 = ComboBox1->Text;
AnsiString pp3 = ".mdb";
AnsiString pp4 = pp0 + pp1 + pp3;
AnsiString pp5 = "C:\\Sebas\\Gestionv.mdb";
AnsiString pp6 = "C:\\Sebas\\BDAnual.mdb";
AnsiString Ruta,Ruta2,Ruta3,Anio;
String sDesktopPath;
LPITEMIDLIST ItemID;
SHGetSpecialFolderLocation(Handle,CSIDL_DESKTOPDIRECTORY,&ItemID);
if(ItemID != NOERROR)
{
char szDirPath[MAX_PATH];
SHGetPathFromIDList(ItemID,szDirPath);
sDesktopPath = szDirPath;
if (sDesktopPath[sDesktopPath.Length()]!='\\') sDesktopPath += "\\";
}
else throw Exception ("Error :: SHGetSpecialFolderLocation");
getdate(&d);
Anio = IntToStr(d.da_year);
// Creación de la carpeta en el escritorio
Ruta = sDesktopPath + Anio + "\\" + ComboBox1->Text;
Ruta2 = Ruta + "\\" + pp1 + pp3;
Ruta3 = Ruta + "\\" + "BDAnual.mdb";
if ((DirectoryExists(Ruta)) == true){//Si el directorio existe es que ya se ha creando anteriormente por lo que no hay que crearlo
if ((FileExists(Ruta2)) == true){ // Si existe el fichero no hay que sobreescribirlo
}
else{
CopyFile(pp5.c_str(),Ruta2.c_str(),false);
}
if ((FileExists(Ruta3)) == true){ // Si existe el fichero no hay que sobreescribirlo
}
else{
CopyFile(pp5.c_str(),Ruta3.c_str(),false);
}
ShowMessage("No se puede crear el directorio " + ComboBox1->Text+ " en el DeskTop porque la carpeta ya existe");
}
else{ // Si el directorio no existe entonces tampoco existen los ficheros que tienen que contener
CreateDir(Ruta);
CopyFile(pp5.c_str(),Ruta2.c_str(),false);//Copia de la BD del mes en el que se hace
CopyFile(pp5.c_str(),Ruta3.c_str(),false);// Copia la BD Anual
CopyFile(pp5.c_str(),pp4.c_str(),false); // Copia BD del mes en el directorio Sebas
ShowMessage("Se ha creado la copia de seguridad " + pp4);
}
for (cont = 0; cont<=8; cont++){
Query1->SQL->Clear();
DBGrid1->Refresh();
Query1->SQL->Add("Select * from :parametro");
RP = BD[cont];
Query1->Params->Items[0]->AsString = BD[cont];
Query1->Prepare();
Query1->Open();
Edit1->Text = IntToStr(DBGrid1->FieldCount);
col = DBGrid1->FieldCount;
Edit10->Text = IntToStr(pDS->RecordCount);
for ( i = 1; i <= pDS ->RecordCount; i++){ //2
if (cont == 6){
DBGrid1->Refresh();
Query3->SQL->Clear();
Query3->SQL->Add("Select * from " + BD[cont] + "where NVerraco =:numero and FechaAnalisis =:fecha");
Query3->Params->Items[0]->AsString = pDS->Fields->Fields[0]->AsString;
Query3->Params->Items[1]->AsString = pDS->Fields->Fields[2]->AsString;
Query3->Prepare();
Query3->Open();
Edit10->Text = IntToStr(pDS->RecordCount);
Edit11->Text = IntToStr(Query3->RecordCount); // Miro si el registro existe.
if (Edit11->Text == '0'){ //4
// Hay que insertar el registro porque no existe
// Para registros nuevos
Query2->SQL->Clear();
Query2->SQL->Add("Insert into" + BD[cont]+ "(NVerraco, Raza, FechaAnalisis, GCP, GCD, ColasAnormales, CabezasAnormales, AcrosomasAnormales, TotalAnomalias) Values(:a, :b, :c, :d, :e, :f, :g, :h, :i)");
Query2->Params->Items[0]->AsString = pDS->Fields->Fields[0]->AsString;
Query2->Params->Items[1]->AsString = pDS->Fields->Fields[1]->AsString;
Query2->Params->Items[2]->AsString = pDS->Fields->Fields[2]->AsString;
Query2->Params->Items[3]->AsString = pDS->Fields->Fields[3]->AsString;
Query2->Params->Items[4]->AsString = pDS->Fields->Fields[4]->AsString;
Query2->Params->Items[5]->AsString = pDS->Fields->Fields[5]->AsString;
Query2->Params->Items[6]->AsString = pDS->Fields->Fields[6]->AsString;
Query2->Params->Items[7]->AsString = pDS->Fields->Fields[7]->AsString;
Query2->Params->Items[8]->AsString = pDS->Fields->Fields[8]->AsString;
Query2->Prepare();
Query2->ExecSQL();
pDS->Next();
}//4
}
if (cont == 7){
DBGrid1->Refresh();
Query3->SQL->Clear();
Query3->SQL->Add("Select * from" + BD[cont] + "where NVerraco =:numero and MesExtr =:fecha");
Query3->Params->Items[0]->AsString = pDS->Fields->Fields[0]->AsString;
Query3->Params->Items[1]->AsString = ComboBox1->Items->Strings[0];
Query3->Prepare();
Query3->Open();
Edit10->Text = IntToStr(pDS->RecordCount);
Edit11->Text = IntToStr(Query3->RecordCount); // Miro si el registro existe.
if (Edit11->Text == '0'){ //4
// Hay que insertar el registro porque no existe
// Para registros nuevos
Query2->SQL->Clear();
Query2->SQL->Add("Insert into" + BD[cont] + "(NVerraco, Raza, FechaExtr, MesExtr, Volumen, TMovimiento, CalidadMovimiento, Aglutinacion, PorcentajeNormales, Absorvancia, Concentracion, NDosis1, NDosis2, VolumenDiluyente, ValorR, Destino1, Destino2, Observaciones, NVerracosExtraidos, NDosisVerraco, DosisEyaculado, SumaTDosis) Values(:a, :b, :c, :d, :e, :f, :g, :h, :i, :j, :k, :l, :m, :n,
, :p, :q, :r, :s, :t, :v)");
Query2->Params->Items[0]->AsString = pDS->Fields->Fields[0]->AsString;
Query2->Params->Items[1]->AsString = pDS->Fields->Fields[1]->AsString;
Query2->Params->Items[2]->AsString = pDS->Fields->Fields[2]->AsString;
Query2->Params->Items[3]->AsString = pDS->Fields->Fields[3]->AsString;
Query2->Params->Items[4]->AsString = pDS->Fields->Fields[4]->AsString;
Query2->Params->Items[5]->AsString = pDS->Fields->Fields[5]->AsString;
Query2->Params->Items[6]->AsString = pDS->Fields->Fields[6]->AsString;
Query2->Params->Items[7]->AsString = pDS->Fields->Fields[7]->AsString;
Query2->Params->Items[8]->AsString = pDS->Fields->Fields[8]->AsString;
Query2->Params->Items[9]->AsString = pDS->Fields->Fields[9]->AsString;
Query2->Params->Items[10]->AsString = pDS->Fields->Fields[10]->AsString;
Query2->Params->Items[11]->AsString = pDS->Fields->Fields[11]->AsString;
Query2->Params->Items[12]->AsString = pDS->Fields->Fields[12]->AsString;
Query2->Params->Items[13]->AsString = pDS->Fields->Fields[13]->AsString;
Query2->Params->Items[14]->AsString = pDS->Fields->Fields[14]->AsString;
Query2->Params->Items[15]->AsString = pDS->Fields->Fields[15]->AsString;
Query2->Params->Items[16]->AsString = pDS->Fields->Fields[16]->AsString;
Query2->Params->Items[17]->AsString = pDS->Fields->Fields[17]->AsString;
Query2->Params->Items[18]->AsString = pDS->Fields->Fields[18]->AsString;
Query2->Params->Items[19]->AsString = pDS->Fields->Fields[19]->AsString;
Query2->Params->Items[20]->AsString = pDS->Fields->Fields[20]->AsString;
Query2->Params->Items[21]->AsString = pDS->Fields->Fields[21]->AsString;
Query2->Prepare();
Query2->ExecSQL();
pDS->Next();
}//4
}
if (cont ==
{
DBGrid1->Refresh();
Query3->SQL->Clear();
Query3->SQL->Add("Select * from" + BD[cont] + "where Mes =:numero and Fecha =:fecha");
Query3->Params->Items[0]->AsString = ComboBox1->Items->Strings[0];
Query3->Params->Items[1]->AsString = pDS->Fields->Fields[25]->AsString;
Query3->Prepare();
Query3->Open();
Edit10->Text = IntToStr(pDS->RecordCount);
Edit11->Text = IntToStr(Query3->RecordCount); // Miro si el registro existe.
if (Edit11->Text == '0'){ //4
// Hay que insertar el registro porque no existe
// Para registros nuevos
Query2->SQL->Clear();
Query2->SQL->Add("Insert into" + BD[cont] + "Mes, CP1, CP2, TX, MH, DH, Duroc, LW, Pietrain, AbueloDal, AbueloSeg, Bisabuelo, SumaTotal, SDuroc, SLargeWhite, SPietrain, SAbueloDal, SAbueloSeg, SBisabuelo, MDuroc, MLargeWhite, MPietrain, MAbueloDal, MAbueloSeg, MBisabuelo, Fecha) Values(:a, :b, :c, :d, :e, :f, :g, :h, :i, :j, :k, :l, :m, :n,
, :p, :q, :r, :s, :t, :v, :w, :w, :y, :z)");
Query2->Params->Items[0]->AsString = pDS->Fields->Fields[0]->AsString;
Query2->Params->Items[1]->AsString = pDS->Fields->Fields[1]->AsString;
Query2->Params->Items[2]->AsString = pDS->Fields->Fields[2]->AsString;
Query2->Params->Items[3]->AsString = pDS->Fields->Fields[3]->AsString;
Query2->Params->Items[4]->AsString = pDS->Fields->Fields[4]->AsString;
Query2->Params->Items[5]->AsString = pDS->Fields->Fields[5]->AsString;
Query2->Params->Items[6]->AsString = pDS->Fields->Fields[6]->AsString;
Query2->Params->Items[7]->AsString = pDS->Fields->Fields[7]->AsString;
Query2->Params->Items[8]->AsString = pDS->Fields->Fields[8]->AsString;
Query2->Params->Items[9]->AsString = pDS->Fields->Fields[9]->AsString;
Query2->Params->Items[10]->AsString = pDS->Fields->Fields[10]->AsString;
Query2->Params->Items[11]->AsString = pDS->Fields->Fields[11]->AsString;
Query2->Params->Items[12]->AsString = pDS->Fields->Fields[12]->AsString;
Query2->Params->Items[13]->AsString = pDS->Fields->Fields[13]->AsString;
Query2->Params->Items[14]->AsString = pDS->Fields->Fields[14]->AsString;
Query2->Params->Items[15]->AsString = pDS->Fields->Fields[15]->AsString;
Query2->Params->Items[16]->AsString = pDS->Fields->Fields[16]->AsString;
Query2->Params->Items[17]->AsString = pDS->Fields->Fields[17]->AsString;
Query2->Params->Items[18]->AsString = pDS->Fields->Fields[18]->AsString;
Query2->Params->Items[19]->AsString = pDS->Fields->Fields[19]->AsString;
Query2->Params->Items[20]->AsString = pDS->Fields->Fields[20]->AsString;
Query2->Params->Items[21]->AsString = pDS->Fields->Fields[21]->AsString;
Query2->Params->Items[22]->AsString = pDS->Fields->Fields[22]->AsString;
Query2->Params->Items[23]->AsString = pDS->Fields->Fields[23]->AsString;
Query2->Params->Items[24]->AsString = pDS->Fields->Fields[24]->AsString;
Query2->Params->Items[25]->AsString = pDS->Fields->Fields[25]->AsString;
Query2->Prepare();
Query2->ExecSQL();
pDS->Next();
}//4
}
if (cont < 6){ //cont < 6
Edit10->Text = IntToStr(pDS->RecordCount);
Edit2->Text = pDS->Fields->Fields[0]->AsString;
Edit3->Text = pDS->Fields->Fields[1]->AsString;
Edit4->Text = pDS->Fields->Fields[2]->AsString;
Edit5->Text = pDS->Fields->Fields[3]->AsString;
Edit6->Text = pDS->Fields->Fields[4]->AsString;
Edit7->Text = pDS->Fields->Fields[5]->AsString;
CheckBox1->Checked = pDS->Fields->Fields[6]->AsBoolean;
Edit9->Text = IntToStr(DBGrid1->SelectedRows->Count);
if (Edit4->Text == "") Edit4->Text = 00-00-0000;
if (Edit6->Text == "") Edit6->Text = 00-00-0000;
Query3->SQL->Clear();
Query3->SQL->Add("Select * from" + BD[cont] + "where NVerraco =:numero and FechaEntrada =:fecha");
Query3->Params->Items[0]->AsString = Edit2->Text;
Query3->Params->Items[1]->AsString = Edit5->Text;
Query3->Prepare();
Query3->Open();
Edit11->Text = IntToStr(Query3->RecordCount); // Miro si el registro existe.
if (Edit11->Text == '1'){//3
// Hay que hacer un update porque el fichero ya esta
// Para registros que hay que actualizar
Query4->SQL->Clear();
Query4->SQL->Add("Update" + BD[cont] + "Set Matadero = :valor where NVerraco =:numero and FechaEntrada =:fecha");
Query4->Params->Items[0]->AsBoolean = CheckBox1->Checked;
Query4->Params->Items[1]->AsString = Edit2->Text;
Query4->Params->Items[2]->AsString = Edit5->Text;
Query4->Prepare();
Query4->ExecSQL();
pDS->Next();
}//3
if (Edit11->Text == '0'){ //4
// Hay que insertar el registro porque no existe
// Para registros nuevos
Query2->SQL->Clear();
Query2->SQL->Add("Insert into" + BD[cont] + "(NVerraco, Crotal, FechaExtr, FechaEntrada, FechaSalida, FechaPrimeraExtra, Matadero) Values(:a, :b, :c, :d, :e, :f, :g)");
Query2->Params->Items[0]->AsString = Edit2->Text;
Query2->Params->Items[1]->AsString = Edit3->Text;
Query2->Params->Items[2]->AsString = Edit4->Text;
Query2->Params->Items[3]->AsString = Edit5->Text;
Query2->Params->Items[4]->AsString = Edit6->Text;
Query2->Params->Items[5]->AsString = Edit7->Text;
Query2->Params->Items[6]->AsBoolean = CheckBox1->Checked;
Query2->Prepare();
Query2->ExecSQL();
pDS->Next();
}//4
}// cont < 6
}
}
try{
Query10->Prepare();
Query10->ExecSQL();
}
catch(...){}
try{
Query11->Prepare();
Query11->ExecSQL();
}
catch(...){}
try{
Query12->Prepare();
Query12->ExecSQL();
}
catch(...){}
try{
Query13->Prepare();
Query13->ExecSQL();
}
catch(...){}
try{
Query14->Prepare();
Query14->ExecSQL();
}
catch(...){}
try{
Query15->Prepare();
Query15->ExecSQL();
}
catch(...){}
try{
Query16->Prepare();
Query16->ExecSQL();
}
catch(...){}
try{
Query17->SQL->Clear();
Query17->SQL->Add("Delete * from AnalisisExtraccion where MesExtr = :p1");
Query17->Params->Items[0]->AsString =ComboBox1->Items->Strings[0];
Query17->Prepare();
Query17->ExecSQL();
}
catch(...){}
try{
Query18->SQL->Clear();
Query18->SQL->Add("Delete * from DosisMensuales where Mes = :p2");
Query18->Params->Items[0]->AsString =ComboBox1->Items->Strings[0];
Query18->Prepare();
Query18->ExecSQL();
}
catch(...){}
try{
Query22->Prepare();
Query22->ExecSQL();
}
catch(...){}
CopyFile(pp6.c_str(),Ruta3.c_str(),false);//Copia de la BDAnual
Close();
}
//---------------------------------------------------------------------------