使用unidac的findkey时发现是区分大小写的,没找到在那可以设置,最后直接修改DBAccess.pas
找到:function TCustomDADataSet.FindKey(const KeyValues: array of const): Boolean;
将:Result := LocateEx(KeyFields, Values, FFindKeyOptions);
修改为:Result := LocateEx(KeyFields, Values, [lxCaseInsensitive]);
保存后重新编译应用就可以。
function TCustomDADataSet.FindKey(const KeyValues: array of const): Boolean; function GetKeyValue(Index: integer): variant; // nearly copied from TField.AssignValue procedure Error; begin DatabaseErrorFmt(SFieldValueError, [IntToStr(Index)]); end; begin Result := Unassigned; with KeyValues[Index] do case VType of vtInteger: Result := Integer(VInteger); vtInt64: Result := VInt64^; vtBoolean: Result := Boolean(VBoolean); {$IFNDEF NEXTGEN} vtChar: Result := String(VChar); {$ENDIF} vtExtended: Result := Extended(VExtended^); {$IFNDEF NEXTGEN} vtString: Result := String(VString^); {$ENDIF} vtPointer, vtObject: if VPointer <> nil then Error; {$IFNDEF NEXTGEN} vtPChar: Result := String(VPChar); vtAnsiString: Result := String(VAnsiString); {$ENDIF} vtCurrency: Result := Currency(VCurrency^); vtVariant: if not VarIsClear(VVariant^) then Result := Variant(VVariant^); vtWideChar: Result := WideString(VWideChar); vtWideString: Result := WideString(VWideString); {$IFDEF VER12P} vtUnicodeString: Result := UnicodeString(VUnicodeString); {$ENDIF} else Error; end; end; var KeyFieldDescs: TFieldDescArray; Values: variant; KeyFieldsCount: integer; KeyFields: TFieldArray; i: integer; begin CheckBrowseMode; FIRecordSet.GetKeyFieldDescs(KeyFieldDescs); Values := Unassigned; // To prevent warning KeyFieldsCount := Length(KeyFieldDescs); SetLength(KeyFields, KeyFieldsCount); case KeyFieldsCount of 0: DatabaseError(SKeyFieldsRequired); 1: begin KeyFields[0] := GetField(KeyFieldDescs[0]); Values := GetKeyValue(0); end; else begin Values := VarArrayCreate([0, KeyFieldsCount - 1], varVariant); for i := 0 to KeyFieldsCount - 1 do begin KeyFields[i] := GetField(KeyFieldDescs[i]); if i <= High(KeyValues) then Values[i] := GetKeyValue(i) else Values[i] := Unassigned; end; end; end; Result := LocateEx(KeyFields, Values,, [lxCaseInsensitive]); end;
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列:向量存储与相似性搜索在 .NET 中的实现
· 基于Microsoft.Extensions.AI核心库实现RAG应用
· Linux系列:如何用heaptrack跟踪.NET程序的非托管内存泄露
· 开发者必知的日志记录最佳实践
· TypeScript + Deepseek 打造卜卦网站:技术与玄学的结合
· Manus的开源复刻OpenManus初探
· AI 智能体引爆开源社区「GitHub 热点速览」
· 从HTTP原因短语缺失研究HTTP/2和HTTP/3的设计差异
· 三行代码完成国际化适配,妙~啊~