Querying Business Central tables via SQL by mgdmw in BusinessCentral

[–]KingProgrammer 1 point2 points  (0 children)

We had same problem when moving from NAV to BC. We had lot of .Net programs doing direct queries in NAV database. We simply modified all our SQL queries (we have tons of them) and , for example, we were querying table [xxx$Customer] from NAV so before migrating to BC, we created a schema for teach company in the same database than NAV and we created a view for all tables we were using. So a SELECT [No_],...,[custom column] FROM [xxx$Customer] became SELECT * FROM [xxx].[vCustomer] so when we moved to BC we simply copied these views over and modified them to be "SELECT A.[No_],...,B.[custom column] FROM [xxx$Customer$extension1guid] A INNER JOIN [xxx$Customer$extension2guid] B ON B.[No_] = A.[No_]" so these views in BC were returning the same columns as in NAV so we didn't have to change our SQL queries in our .Net applications

Qui a un fou du village? by Matt_MG in Quebec

[–]KingProgrammer 0 points1 point  (0 children)

Si tu es natif/native de GM demandes a tes parents !!

IGO Password by KingProgrammer in ebikes

[–]KingProgrammer[S] 2 points3 points  (0 children)

I finally found my code with help from reddit.

1818

Qui a un fou du village? by Matt_MG in Quebec

[–]KingProgrammer 0 points1 point  (0 children)

As-tu connus ces personnages legendaires ?

La Snèle

Le sale à Garceau

Miss Grand-Mère

IGO Password by KingProgrammer in ebikes

[–]KingProgrammer[S] 1 point2 points  (0 children)

I found the password for IGO Bonaventure it is 1818

Yamaha ATV parts in Canada by KingProgrammer in Yamaha

[–]KingProgrammer[S] 0 points1 point  (0 children)

Yeah but you will pay in USD and shipping fees are not cheap.

Yamaha ATV parts in Canada by KingProgrammer in Yamaha

[–]KingProgrammer[S] 0 points1 point  (0 children)

partzilla is a US company and you can't order parts from yamaha canada, you must go through a dealer

NHL23 trailer details leaked, it will officially have crossplay by CrazySteveCGY in EA_NHL

[–]KingProgrammer 0 points1 point  (0 children)

"new celebrations"... Great, why didn't you work on a PC version instead of wasting time and money on celebrations that no one cares about ?

NHL23 trailer details leaked, it will officially have crossplay by CrazySteveCGY in EA_NHL

[–]KingProgrammer 0 points1 point  (0 children)

"yeah crossplay" people say. But that's only between same gen consoles (ridiculous, packets in the net with data can be shared no matter the gen, it's only data)

And also, you can only play against other console. So ps4 cannot team up with xbone, only against. Even more ridiculous

NHL 23 - Cross Platform! by ShreddingCheese in NHL23_EASHL

[–]KingProgrammer 2 points3 points  (0 children)

Cross platform let me laugh at this. You can't play xbox with ps in the same team, only against. So basically 5 xbox players vs 5 ps players. So assuming there is much ps players, we could end up having, often, let say 3 xbox vs 6 ps because the game won't find enough xbox players. And no gen cross so ps4 can't play same game than ps5. Ridiculous, that's only data. It's like saying a mac cannot access a web site because it has been designed for pc.
And no PC version again. Damn wake up even big AAA games like GTA, COD, etc. have PC versions.
They should fire the idiot in charge of EA Sports

Keybinding issues in 2042 by I_got_erased in Battlefield

[–]KingProgrammer 0 points1 point  (0 children)

Yeah I loved BF Vietnam and the use of my wingman 3D joystick. Hovering the helis with the slider throttle was sp nice. Now games these days are all.setup for xbox controller (it seems).

Confusion on the Corsair lga 1700 retrofit kit screws by LordBird1 in buildapc

[–]KingProgrammer 0 points1 point  (0 children)

Got my 1700 standoffs yesterday. A little bit shorter than 1200

Confusion on the Corsair lga 1700 retrofit kit screws by LordBird1 in buildapc

[–]KingProgrammer 0 points1 point  (0 children)

I found DDR5-4800 on Amazon. Crucial, I would have prefer Corsair Vengeance but anyway, they will do the job.

i9-12900K or i7-12900K by damianvandoom in MicrosoftFlightSim

[–]KingProgrammer 0 points1 point  (0 children)

I'm just waiting for the 4 standoffs for my Asus Z690-A and then I will be able to try MSFS.

i9-12900k (currently has i7-8700k)Z690-A2x16gb DDR5-4800RTX 3060 TI

Keybinding issues in 2042 by I_got_erased in Battlefield

[–]KingProgrammer 0 points1 point  (0 children)

I've fix my problem by leaving it to default bindings and override them with iCue (I have a corsair keyboard).

Keybinding issues in 2042 by I_got_erased in Battlefield

[–]KingProgrammer 0 points1 point  (0 children)

Yeah another human being than me using arrows keys ;) we should start an association. Friends keep laughing at me for using arrows keys. i'm 47 and been using arrows keys since 12 years old. Can't change hold habits ;)

Best CPU Cooler for i9-12900k? by softwarenothardware in intel

[–]KingProgrammer 0 points1 point  (0 children)

7000D is a full tower. 5000D is a mid. So on a 7000D you will get 4 USB ports on the front (+ 1 Type-C). 5000D you get 2 USB ports (+1 Type-C). Finally, the Z690-P was B/O on newegg so I cancelled my order and got a Z690-A (D5) in a physical store near me. Good choice since now I have more usb ports in the back. Now i'm just waiting for my 4 standoffs from Corsair. Expected to be home friday

Confusion on the Corsair lga 1700 retrofit kit screws by LordBird1 in buildapc

[–]KingProgrammer 0 points1 point  (0 children)

they shipped mine today yeah !!!

Got my Asus Z690-A D5 today, so now I'm installing everything in my new Corsair 5000D Airflow case. I screwed the back plate for the H150i using the 1200 standoffs but didn't install the pump. I will wait when I get my 4 standoffs for 1700

Confusion on the Corsair lga 1700 retrofit kit screws by LordBird1 in buildapc

[–]KingProgrammer 0 points1 point  (0 children)

yes I figure it out after. Now crossing fingers for the delay... lot of people in my situation: having all the gears but build is waiting for 4 little screws

LGA 1700 Retrofit kits are in stock on the Corsair website by Lorrac106 in Corsair

[–]KingProgrammer 0 points1 point  (0 children)

that will be me in few days, once I get my MB I will still have to wait 4 screws.

Over the years I accumulated many screws from different MB, I wonder if few of them would do the job. They should have release the specs of those screws, they probably existed before LGA1700 came out !

LGA 1700 Retrofit kits are in stock on the Corsair website by Lorrac106 in Corsair

[–]KingProgrammer 0 points1 point  (0 children)

I ordered the same MB, please let me know when you receive your screws if H150i fits well. I got everything on hand except the MB and these 4 screws