|
The best option is divide your string.
and at last concatenate the strings while sending a parameter to an execute statement.
As a String will take at max 255 characters.If u try more than 255 characters it will neglect the characters more than 255 and end with NULL.
|
|
|
|
|
i have create connectiong with MS Access database
i know how to retrive/save text vlues from/to table feilds of MS DataBase
but i am unable to get date and convert its formate
for text geting text values from feilds i am using following code:
CDaoDatabase db;
CDaoRecordset recset(&db);
db.Open("patient.mdb");
Sql = "SELECT * FROM patient WHERE (LastName LIKE '"+temp+"*')";
recset.Open(AFX_DAO_USE_DEFAULT_TYPE,Sql,NULL);
while(!recset.IsEOF())
{
recset.GetFieldValue("lastname",var);
Client = (LPCSTR)var.pbstrVal;
b->AddString(Client);
recset.MoveNext();
}
|
|
|
|
|
If you try to retrieve the date you will get the value in string Format rather than DateTime format
So once you retrive the date .you have to Format the string.
can you send the table information
|
|
|
|
|
database name is "patient"
table name is "patient"
feilds are
firstname txt
lastname txt
date date
this table is in ms access 97
|
|
|
|
|
Please stop reposting same question again and again.
Regards,
Sandip.
|
|
|
|
|
hi:
i just need to creat a really simple application (thinking using VB2005 C++), that has a single up/down bar that control the master volume in windows. there are few question i met while searching the information throught the internet:
1. Some people told me that i need to "talk" to the windows first, and find out which services control the audio parts (Is it mmsystem.dll?) do this relate to window message loop?
2. i m thinking using VB2005 to create the GUI, when the bar goes up or down that create an event, and under that event is where i put my code in to set the volume. am i on the right logic?
sorry for being such noob in programming and ask stupid question, i m just a beginner.
thank you for the help
|
|
|
|
|
From your question it sounds like you don't have much experience with C++ or MFC.
Perhaps you should gain some more confidence before tackling this job.
“Cannot find REALITY.SYS...Universe Halted.”
~ God on phone with Microsoft Customer Support
|
|
|
|
|
Maybe you can use Audio Mixers[^]
FWIW - Definitely the worst API I've ever used....even more fun on Vista
Mark
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
i have stored dates in MS ACCESS file
field name is DATE and formate is mm/dd/yyyy
now i want to retirve date from database using vc++
and want to convert date in any other formate
plzzz helppp
|
|
|
|
|
|
i have create connectiong with MS Access database
i know how to retrive/save text vlues from/to table feilds of MS DataBase
but i am unable to get date and convert its formate
for text geting text values from feilds i am using following code:
CDaoDatabase db;
CDaoRecordset recset(&db);
db.Open("patient.mdb");
Sql = "SELECT * FROM patient WHERE (LastName LIKE '"+temp+"*')";
recset.Open(AFX_DAO_USE_DEFAULT_TYPE,Sql,NULL);
while(!recset.IsEOF())
{
recset.GetFieldValue("lastname",var);
Client = (LPCSTR)var.pbstrVal;
b->AddString(Client);
recset.MoveNext();
}
|
|
|
|
|
how can i suspend a thread from some other thread ,i used SuspendThread method but it has no effect .
|
|
|
|
|
Don't use SuspendThread . See here[^] for details.
Steve
|
|
|
|
|
SuspendThread might be failing with an error.
Put this line of code directly after the call to SuspendThread:
DWORD Error = GetLastError();
Then, inspect the Error value to learn what Win32 error occured.
You can look up the error code in the program "errlook" provided with the platform SDK.
“Cannot find REALITY.SYS...Universe Halted.”
~ God on phone with Microsoft Customer Support
|
|
|
|
|
In addition to Stephen's reply, you can read about the same problem here[^].
The only sane place to suspend a thread is from the thread itself.
Use may use an event or a volatile declared boolean, or a user message if it's a UI-thread, to instruct the thread to suspend itself.
"It's supposed to be hard, otherwise anybody could do it!" - selfquote "High speed never compensates for wrong direction!" - unknown
|
|
|
|
|
you can use AfxEndThread()
or
KillThread()
or you can send a notification to a thread to exit
|
|
|
|
|
Hi guys
Does anybody know what the equivalent of ldexpl() is in C#.Net?
Any pointers would be appreciated.
Thanks.
|
|
|
|
|
You might try asking in the C# forum.
“Cannot find REALITY.SYS...Universe Halted.”
~ God on phone with Microsoft Customer Support
|
|
|
|
|
Hi i have one doubt regarding how to generate XML file output for example;
main()
{
int Array_sample[];
for(int i=0;i<=10;i++)
{
Array_sample[i]=i;
std::cout<<Array_sample[i]<<std::endl;
}
return 0;
}
Thanks and Regards
Nisha
|
|
|
|
|
#include <iostream>
#include <c++/3.4.5/fstream>
using namespace std;
int main()
{
int Array_sample[10];
fstream myOutput;
myOutput.open("test.xml", fstream::out);
myOutput<<"<?xml version=\"1.0\" encoding=\"Windows-1252\"?>"<<endl;
myOutput<<"<numbers>"<<endl;
for(int i=0;i<=10;i++)
{
Array_sample[i]=i;
myOutput<<"\t<item>"<<Array_sample[i]<<"</item>"<<endl;
}
myOutput<<"</numbers>"<<endl;
myOutput.close();
return 0;
}
[EDIT:] screwed-up the quotation marks. They're fixed now.
|
|
|
|
|
you are simply writing in console print XML senerio ...i want to generate one external XML file
|
|
|
|
|
No .. he is actually writing to a "test.xml" file.. not stdout
myOutput.open("test.xml", fstream::out);
regards
Fratelli
|
|
|
|
|
I'd normally be more polite, but you sir nisha0000, are a donkey!
It creates test.xml as it's output. For ****'s sake - try actually compiling it.
|
|
|
|
|
how to check date formate in vc++
how to set date formate in vc++
|
|
|
|
|
ani_ikram wrote: how to check date formate in vc++
GetDateFormat()
ani_ikram wrote: how to set date formate in vc++
Something like this:
CDateTimeCtrl* pCtrl = (CDateTimeCtrl*) GetDlgItem(IDC_DATETIMEPICKER1);
ASSERT(pCtrl != NULL);
pCtrl->SetFormat(_T("MM-dd-yy"));
//Also check COleDateTime::SetFormat
Somethings seem HARD to do, until we know how to do them.
_AnShUmAn_
|
|
|
|