Click here to Skip to main content
14,356,068 members
   

Delphi

 
AnswerRe: About Delphi KeyBoard Hook question,I need your help ! Pin
Dr.Walt Fair, PE12-Dec-10 13:36
professionalDr.Walt Fair, PE12-Dec-10 13:36 
AnswerRe: About Delphi KeyBoard Hook question,I need your help ! Pin
nortee12-Dec-10 22:44
membernortee12-Dec-10 22:44 
AnswerRe: About Delphi KeyBoard Hook question,I need your help ! Pin
GAMerritt18-Jan-11 5:52
memberGAMerritt18-Jan-11 5:52 
QuestionExposing C# COM server Events to Delphi client Pin
shilan_hk11-Jun-10 23:08
membershilan_hk11-Jun-10 23:08 
AnswerRe: Exposing C# COM server Events to Delphi client Pin
dan_fish23-Aug-10 3:46
memberdan_fish23-Aug-10 3:46 
QuestionDelphi DLL function calling from VB.net and C#.net paramters compatibility Pin
vijay.victory12-Apr-10 1:39
membervijay.victory12-Apr-10 1:39 
AnswerRe: Delphi DLL function calling from VB.net and C#.net paramters compatibility Pin
mobius11100112-Apr-10 3:37
membermobius11100112-Apr-10 3:37 
QuestionUnicode parameter in Select Query Pin
vijay.victory31-Mar-10 20:28
membervijay.victory31-Mar-10 20:28 
I want to search the record by a word which is Unicode.
So I can give it in SQL Mgnt Studio like this..

select VocNo from VocableMaster where VocDescSan like N'अपाप'


It can give me result.where 'N' denotes it is Unicode string.
But I cant send it via Delphi.


I tried following ways :-
<code>1> select VocNo from VocableMaster where VocDescSan like N'''+reVocSan.Text+'''
</code>

then it gives me no result becoz reVocSan.Text will be '????'(due to unicode)

<code>
2>select VocNo from VocableMaster where VocDescSan like N:VocDescSan)) and ');
            Parameters.ParamByName('VocDescSan').DataType := ftWideString;
            Parameters.ParamByName('VocDescSan').Value := reVocSan.Text;</code>

then it will give error about VocDescSan parameter not found. bcoz it combines both N and para.

3>select VocNo from VocableMaster where VocDescSan like N :VocDescSan)) and ');
            Parameters.ParamByName('VocDescSan').DataType := ftWideString;
            Parameters.ParamByName('VocDescSan').Value := reVocSan.Text;


then it will give error about Column Name not found for 'N' (if space between N and para)
4>select VocNo from VocableMaster where VocDescSan like N+:VocDescSan)) and ');
            Parameters.ParamByName('VocDescSan').DataType := ftWideString;
            Parameters.ParamByName('VocDescSan').Value := reVocSan.Text;


then it will give error about Column Name not found for 'N'
<code>5>select VocNo from VocableMaster where VocDescSan like :VocDescSan)) and ');
            Parameters.ParamByName('VocDescSan').DataType := ftWideString;
            Parameters.ParamByName('VocDescSan').Value := reVocSan.Text;</code>


then it will not give any error. but couldnt give any Result.

I will check it in SQL mgnt Studio.
select VocNo from VocableMaster where VocDescSan like 'अपाप'



Can anyone have solution for this..
I have never failed,I just found 1000 ways that never works.
Regards,
Victory.

AnswerRe: Unicode parameter in Select Query Pin
nortee13-Dec-10 22:34
membernortee13-Dec-10 22:34 
QuestionFreeDOS Scandisk - Compilation Errors for Pascal code Pin
Low_Level14-Mar-10 6:50
memberLow_Level14-Mar-10 6:50 
AnswerRe: FreeDOS Scandisk - Compilation Errors for Pascal code Pin
Richard MacCutchan14-Mar-10 8:13
protectorRichard MacCutchan14-Mar-10 8:13 
GeneralRe: FreeDOS Scandisk - Compilation Errors for Pascal code Pin
Low_Level14-Mar-10 8:31
memberLow_Level14-Mar-10 8:31 
GeneralRe: FreeDOS Scandisk - Compilation Errors for Pascal code Pin
Low_Level14-Mar-10 8:33
memberLow_Level14-Mar-10 8:33 
QuestionSQL Server 2005 Connection Strings.....Some Important Queries Pin
vijay.victory5-Mar-10 22:28
membervijay.victory5-Mar-10 22:28 
AnswerRe: SQL Server 2005 Connection Strings.....Some Important Queries Pin
Eddy Vluggen6-Mar-10 2:11
mveEddy Vluggen6-Mar-10 2:11 
QuestionSlow Performance of SQL Server 2005... Pin
vijay.victory3-Mar-10 3:51
membervijay.victory3-Mar-10 3:51 
AnswerRe: Slow Performance of SQL Server 2005... Pin
Stryder_13-Mar-10 5:36
memberStryder_13-Mar-10 5:36 
GeneralRe: Slow Performance of SQL Server 2005... Pin
vijay.victory4-Mar-10 18:25
membervijay.victory4-Mar-10 18:25 
AnswerRe: Slow Performance of SQL Server 2005... Pin
dan_fish3-Mar-10 6:12
memberdan_fish3-Mar-10 6:12 
GeneralRe: Slow Performance of SQL Server 2005... Pin
vijay.victory4-Mar-10 18:29
membervijay.victory4-Mar-10 18:29 
GeneralRe: Slow Performance of SQL Server 2005... Pin
dan_fish5-Mar-10 0:03
memberdan_fish5-Mar-10 0:03 
QuestionDecrypt, validate and read large XML files Pin
abeaumont25-Feb-10 3:19
memberabeaumont25-Feb-10 3:19 
AnswerRe: Decrypt, validate and read large XML files Pin
dan_fish26-Feb-10 1:54
memberdan_fish26-Feb-10 1:54 
AnswerRe: Decrypt, validate and read large XML files Pin
nortee12-Dec-10 23:42
membernortee12-Dec-10 23:42 
QuestionNeed help compiling a project Pin
Member 386233915-Feb-10 9:43
memberMember 386233915-Feb-10 9:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.