|
Danoo wrote:
SELECT * FROM Songs WHERE Title LIKE '%D'
What do you want the statement to return ? This is a valid SQL statement, but I suspect your search string is formatted incorrectly.
If you want to search for all names beginning with "PAL", then you would use:
select * from [mytable] where [field] like 'PAL%'
It might be worth mentioning as well that I'm using ADO to format my queries. I think that DAO, and ACCESS uses '*' instead of '%'. (don't quote me on that though)
I Dream of Absolute Zero
|
|
|
|
|
RChin wrote:
...ACCESS uses '*' instead of '%'. (don't quote me on that though)
You are correct. Quote away!
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
Thanks guys, I didn't knew about the wildcard difference between * and %
Regards
Daniel
|
|
|
|
|
Danoo wrote:
SELECT * FROM Songs WHERE Title LIKE '%D'
I am assuming that you want to retrieve all songs information whose titles END with the letter D.
Are you able to run this query through the query analyzer and what is the output?
Because the Query seems correct as far as syntax is concerned, or maybe i just need more caffeine
"Creating tomorrow's legacy systems today.....
.... One CRISIS at a time!" -- Unknown
"If you build it....
.....BUGS will come!" -JB
this.Dispose();
"A Bug is a piece of <sup> code </sup> that knows whatz its purpose"
|
|
|
|
|
Hi All,
Using CSplitterWnd class I can split the window in row X column statically.
But I want to split the window as shown below:
|---------------------------|
| | |
|------| |
| | |
| |--------------------|
| | | |
| | | |
|------|--------------------|
How can I do this?
Please, any one has the code for it? any clues?
Thanks & Regards,
Neeranjan
|
|
|
|
|
Neeranjan wrote:
Please, any one has the code for it?
Search MSDN for the GENSPLIT example. It has four panes.
Here is a CP article that has three panes.
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
My dialog application is running more instances of itself
by calling CreateProcess() to run some tasks (no, i can't use threads).
Is there some way how to debug not only main process, but also child processes, to check memory leaks, see TRACE output, etc ?
Attaching another visual studio instances to all child processes is
lot of work and it can't catch events before before debugger attaching.
Any idea how to do this ?
Thanks !
rrrado
|
|
|
|
|
add the line
__asm int 3
to any intialization function in your process, it will attach the JIT debugger automatically.
Papa
while (TRUE)
Papa.WillLove ( Bebe ) ;
|
|
|
|
|
Thank you ! ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif) 
rrrado
|
|
|
|
|
A question how typical Dispatch-Interfaces are designed:
Imagine you provide a Script client with a method returning a safearray, like this:
HRESULT GetData([out, retval] SAFEARRAY ** data)
Do you return a "complete copy", or can/should you return a reference to internal data held by the component?
we are here to help each other get through this thing, whatever it is Vonnegut jr.
sighist || Agile Programming | doxygen
|
|
|
|
|
I would have thought that you would need to return a copy.
I don't think you can access data across processes just by reference, some sort of accessor functions would be required.
Ant.
I'm hard, yet soft.
I'm coloured, yet clear.
I'm fruity and sweet.
I'm jelly, what am I? Muse on it further, I shall return! - David Williams (Little Britain)
|
|
|
|
|
Ofcourse it will be a reference to the actual memory location allocated from the com server.
A SAFEARRAY we create using by SafeArrayCreate or a BSTR we create by using SysAllocString are independent of the component which creates them. The client can manipulate the server allocated memory location. Remember in the case of a BSTR, the server calls SysAllocString and the client has the responsibility to call release by calling SysFreeString. Its like the server calls new and the client calls delete.
Or it is just like a com object we create inside a com server ( using CComObject ) and a cleint manipulates the properties of that server created object.
hope this helps..
rgds..mil10
|
|
|
|
|
Hi,
We specify the next step number for the resources, commands and control by the following.
_APS_NEXT_RESOURCE_VALUE
_APS_NEXT_COMMAND_VALUE
_APS_NEXT_CONTROL_VALUE
Do we have any way to restrict the numbers or specify the max limit.
eg. I want my resource to have command values from 1 to 100. So
#define _APS_NEXT_COMMAND_VALUE 1 // Next command number
Can I specify somewhere in the resource.h file saying 100 is the max if it goes beyond 100, throw an error?
Thanks,
Prashant.
|
|
|
|
|
PrashantJ wrote:
Can I specify somewhere in the resource.h file saying 100 is the max if it goes beyond 100, throw an error?
No, just don't add more than 100 of that type of resource.
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
I create context menu, receiving OnRButtonDown
from taskbar.
But how to detect that user clicked on someone else
place of desktop ?
- To destroy menu.
Or is it possible to create menu that auto-destroying,
when loosed focus ?
thanks.
______________
I found solution in MSDN
search file sample: CQA0211.exe
With installing hooks, and subclassing system windows...
Does it the right way to implement hiding menu ?
(seems not adequate)
|
|
|
|
|
Ru using TrackpopUpMenu() function call or u r using u r
own customised function?
If u r using TrackPopupMenu() call once u chech hwnd
parameter.
|
|
|
|
|
I USED TrackPopupMenu,
but menu does not disappear, if focus is loosed.
I asked - why it can happen?
|
|
|
|
|
I need to ceate a new file *.net and I want that file to have a own icon is there anyone that now how do to this?
Fast help please.
|
|
|
|
|
you will have to edit the registery,
create a key HKEY_CLASSES_ROOT\.net
with a default value of "NETFILE"
then create the key HKEY_CLASSES_ROOT\NETFILE
to give it an icon
create a sub key named "DefaultIcon" and set its default value to the path of the icon you want to use
then to add menu items to it create another sub key under NETFILE named "shell" then create a sub key under it, with the menu item name then under that key create yet another sub key named "command" and set its default value to the command line you want to use for that menu item, for example
"HKEY_CLASSES_ROOT\txtfile\shell\open\command"=
"C:\WINDOWS\NOTEPAD.EXE %1"
if you arent familiar with editing the registery this will sound very confusing, but its really not, you might check out the articals on shell extensions, i dont know if they cover this or not
|
|
|
|
|
|
Hi,
I am working on Project where i need to know the list of Windows2000 operating system's Users along with their Passwords. Also I want to know the rights or perticular user and want to use it to check for authorization purpose in my software. Any help plz..
My Function is like
void XYZ(int x, char b, char *UserName, char *Password, int UserId)
{
...
...
}
Now in this function I want to check if whether the passed UserName and Password exist on computer or not and if yes then what are the rights of that user...
Any one if able to do ...plz
MacCluny
|
|
|
|
|
serach for network management classes in cp.
-----------------------------
"I Think It will Work"
Formerly Known As "Alok The Programmer" at CP
-----------------------------
Alok Gupta
visit me at http://www.thisisalok.tk
|
|
|
|
|
NetUserEnum[^]?
"It was when I found out I could make mistakes that I knew I was on to something."
-Ornette Coleman
"Philosophy is a study that lets us be unhappy more intelligently."
-Anon.
|
|
|
|
|
Hi all experts...i am a newbie in writing Window service. I need to write a program in c++ which need to run a service for windows xp. I hv no problem in CreateService() and StartService(). But when comes to StartServiceCtrlDispatcher(), it keep returning error 1063 (The service process could not connect to the service controller). Fyi, i was log in as administrator for my mechine. Please help me since i have already stuck here for 2 days... Thanks thanks thanks alot!!!
~bamboo stick~
|
|
|
|
|
If you call StartServiceCtrlDispatcher() and your program is running as a 'regular' executable, you will certianly get this error. The StartServiceCtrlDispatcher() call will only succeed when the service control manager is starting your program. So, if you are running your EXE and starting it under the debugger, then you will ALWAYS see this error. Perhaps you did not fill in the SERVICE_TABLE_ENTRY data correctly. If you did, check the registry to make sure your service got 'installed' correctly.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
