sjordi

For iOS: StartUp\Documents\ For Android: .\assets\internal Use those folders if you deploy an existing DB. This is the Project Options section. At runtime you can use something like this {$IF DEFINED(iOS) or DEFINED(ANDROID)} FDConnection.Params.Values['ColumnMetadataSupported'] := 'False' ; FDConnection.Params.Values['Database'] := TPath.Combine(TPath.GetDocumentsPath, 'mydb.sqlite') ; {$ENDIF} Then do whatever you need to create/open/update, etc...

Where did you turn Metal on? To true? It should be done in the .dpr file, not in a .pas file... That makes a lot of difference. Something like .... {$R *.res} begin {$IF DEFINED(iOS) or DEFINED(MACOS)} GlobalUseMetal := True ; {$ENDIF} Application.Initialize;

I totally second that. XCode is cumbersome yet very powerful but can be intimidating too. Offering a watch equivalent to a main application (smartphone) is a must now and it would really be cool to be able to do this. But if I'm correct, the problem (technical) lies more on the Apple side than Embarcadero. Fingers crossed.

From what I know you need to code your AppleWatch app via XCode only for now. Android watches are different, it works from RadStudio, but not AppleWatch.

Hi All, I try to implement pagination from a SQLite DB that is bound to a TListView. After following the docwiki examples using RecsMax, and RecsSkip on my TFDQuery, I can't find a way to actually have the TListView refresh. If I get only 20 record chunks, I always the same 20 items on my ListView no matter what I do. The problem is that I'd like the user to be able to navigate the TListView up and down transparently without noticing that the TFDQuery is loading the previous/next chunk of data, this for all platforms, so I won't use a PullToRefresh. I tried another example that seems to work on TGrid and TStringGrid... but TListView? Anybody succeeded in getting pages of records and have TListView correctly react? Thanks for any clue Steve

Ok I tried the code above and confirm that it works fine. Disconnect has to be used instead of Close for SQLite. Now with that kind of load, we don't control the vertical scroll bar though. It is just to navigate the current view (nn records we have decided to use for pagination) And the cursor size and position are proportional to those nn records, not the entire set. Maybe I should find a way to better optimize the SQL queries as a workaround. Thanks

Thanks all, I'll try this in the coming days. Was too busy... snow shoeing ! 🙂 I'll let you know if I discover some new things.

Ok I did exactly as you did, but it didn't work. Now instead of FDQuery.Close I set FDQuery.Disconnect instead and now it works... Just like you, I wasn't aware of Disconnect. Now I'll implement this when using the TListView scrolls... looks like OnScrollViewChange will do. Except it doesn't tell in which direction you scroll. But I'll figure this out. Otherwise I'll start a new thread of TListView scrolling events (mouse + finger) 🙂 Thanks a lot for your help. Steve

Do you access an embedded DB ? If yes, do you place it in folders where you have the access right? Just tried with a MovieDB I have, embedding an SQLite database and moved the app into /Applications and it works without trouble. The DB is in the App own Contents\Resources\ directory Just like on iOS when my apps Start and then close immediately, it's related to ressources it doesn't find, like the DB. When I fix the DB path and have them in folder where the app has access rights and then it works without problems.

Well, everything is fine now. For a funny reason it didn’t install the new PA server I installed it manually, deleted the 14.2 SDK, and re-imported it. Now all the folders are correctly imported, And I can compile and deploy without problems

They released a patch today for Big Sur, XCode 12 and SDK 14... Just applied it, installed the new PAServer, compiled a very simple app under SDK 14.2 [DCC Error] E2597 ld: file '\\vmware-host\Shared Folders\Documents\Embarcadero\Studio\SDKs\iPhoneOS14.2.sdk/usr/lib/libiconv.dylib' too small (length=0) for architecture arm64 Switch to 13.7, everything's fine.

This is a known bug, when exiting Delphi 10.3.n Rio or Delphi 10.4 GExperts creates an error. EAccessViolation in module rtl270.bpl ... in module bds.exe Followed by another one : Exception EAssertionFailed in module GExpertsRS104.dll at ... Call DeactivateFontInfo before calling this. ....SynTextDrawer.pas line 475 Since I'm installing Sydney 10.4 I realized (thanks to my VM Snapshots) that GEpxerts behaves perfectly until I install TMS FixInsight. If I take FixInsight out, then the problem is gone. That may be one lead to follow. I have many TMS Components that coexist without problem with GExperts. It seems to appear only once FixInsight is installed. Some users may have that SynTextDrawer error too without this component, but you never know. Just my two cents

I actually found a workaround to let GExperts exit without problem: I install it first before all other FMX, VCL tools right after a clean RADStudio install. If I install it afterwards it always crashes when exiting. Probably one of the 3rd party components screws one of the DLLs and locks it. GExpert doesn't install its own. I have the feeling that the DLL causing problem is locked when GExpert is installed first and stays locked during the entire process, never replaced by anything else, thus saving GExperts 🙂 Don't know...

Ah ok, thanks.

Mhhh, I was actually talking about the video component that can display it in your app. You get the video signal, but which FMX component you use to show the video? Thanks Steve

How do you get video streaming? Are you using a special FMX tool?

Hi all, Just was wondering how to actually link vertical scrollbars to TListViews using FireDac pagination. All the examples and doc about fetching limited rows for huge datasets talk about reacting to a Back or Next action (probably buttons) when you trigger the fetching of the next set, say, next 100 rows. This is done this way: FDQuery1.FetchOptions.RecsSkip := FDQuery1.FetchOptions.RecsSkip+1; But how do we connect this with a vertical scrollbar dynamic movement? Is the idea to 1- get the total number of records 2- get the current vertical scrollbar position (OnScrollViewChange) and calculate where we should proportionally be in the dataset and fetch those rows? It would be awful, very slow, and totally approximate. Or can the scrollbar be synced with the actually dataset in pagination mode in a more natural way? Thanks for any light. I prefer to ask first rather than try code for 3 days without results 🙂 Steve

Installed it in 10.4.1 at the very beginning of the full reinstall. Displayed the SynEdit crash error message. Then when everything was installed, all 3rd parties, I installed the latest GExperts DLL that has been recompiled in 10.4.1 and now no more crashes. Works flawlessly... So I suspect that the next time I'll install everything and GExperts only at the end so it's taking over all other DLLs, and nothing else can screw with it... Just a guess...

Embarcadero states that they are binary compatible within the same version. So that should work right away. Especially the BPL packages

For your information, I installed XCode 11.7 with 10.4.1 and it seems to work. I was able to compile some apps targeted to macOS, iOS, iPadOS and Android without problems, and they all include SQLite embedded DBs deployments. All this seems to work.

I confirm again that the Migration Tool is useless. Just reinstalled 10.4.1 from a clean VM and installed my tools, etc.. then ran the migration to copy the 10.4 settings over 10.4.1 All paths are still not configured, toolbars are out of the box, not the ones I had in 10.4 Useless.

XCode 11.6 or XCode 11.7 released today?

I have tried to use the web installer right in my current VM with 10.4 It fails to uninstall a lot of things, then fails to upgrade correctly. So back to the empty VM and installing everything from scratch. Again.

Full install from scratch or the promised upgrade path on top of 10.4 ? Any idea?

Use the FDConnection BeforeConnect event procedure TdbModule.fdConnectionBeforeConnect(Sender: TObject); {$IF DEFINED(MACOS)} var resourcesPath : String ; newPath : String ; position : Integer ; {$ENDIF)} begin // Get the correct Win, OSX, iOS or Android DB path fdConnection.Params.Values['Database'] := 'mydb.s3db' ; {$IF DEFINED(iOS) or DEFINED(ANDROID)} fdConnection.Params.Values['ColumnMetadataSupported'] := 'False' ; fdConnection.Params.Values['Database'] := TPath.Combine(TPath.GetDocumentsPath, 'mydb.s3db') ; {$ELSEIF DEFINED(MACOS)} resourcesPath := paramstr(0) ; position := Pos( '/Contents', resourcesPath ) ; newPath := paramstr(0).SubString(0, position )+'Contents/Resources/mydb.s3db' ; fdConnection.Params.Values['Database']:= newPath ; {$ENDIF} end; Don't forget to add the db to the Project Deployment window and set Remote Path for each platform: macOS: Contents\Resources\ iOS: StartUp\Documents\ (this one will show up the DB in FileSharing under iTunes or your device finder - You can download, erase, add the file to the app) iOS: Library/Application Support/[your app directory] for files you want accessible from your app but not from the user (not shared) Android: .\assets\internal